Questions tagged [sql-server-7]

I would like to move a database from SQL Server 7.0 to SQL Server 2012. They are not compatible for a backup and restore. Is there a way to export from SQL Server 7.0 and import it to 2012? I only need the tables -- no views or stored procedures.

I need to identify a SQL Server 7 in TSQL. I tried serverproperty but it's not supported in this version. I have sp_MSGetVersion but it returns a table and I don't know how I can get only the version string from this SP.

The entirety of my code is: BEGIN TRAN --SACTION SELECT 1 COMMIT --TRAN with any combination of tran, transaction or neither it always returns error: Incorrect syntax near the keyword 'BEGIN'. I'm using Microsoft SQL Server 7.0. This is a…

I have a box running SQL Server 7 (I know) on Windows XP (I know). All of the sudden, I'm unable to use Windows authentication to connect to the database from the local machine. I can connect using SQL authentication on the local machine. I can…