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