SQL Server 7.0 (major build version 7.00.xxxx). Please also tag sql-server.

learn more… | top users | synonyms

0
votes
0answers
43 views

“begin transaction” yields error

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'...
0
votes
1answer
102 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
62 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
383 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 ...
7
votes
1answer
3k 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 ...