Use this tag for questions specific to the 7.0 version of Microsoft's SQL Server.

learn more… | top users | synonyms

0
votes
1answer
28 views

Windows Authentication Doesn't Work Locally

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 ...
1
vote
0answers
35 views

Identify SQL Server Version in TSQL

I need to identify a SQL Server 7 in TSQL, I try serverproperty but this isnt supported in this version, I have now sp_MSGetVersion but it returns a table and I dont know how I can get only the ...
3
votes
0answers
138 views

Why are we suddenly getting time-outs on multiple transactions? [closed]

Two days ago the transaction log filled up and my user's couldn't update or insert. One of my techs truncated the log, shrank the db, then did a full backup. The next day (Monday) we noticed that ...
6
votes
1answer
1k views

How do you move a SQL Server 7 database to SQL Server 2012?

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 ...