Questions tagged [sql-server-7]

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

SQL Server 7.0 code name Sphinx. Major versions:

  1. 7.0.623 - RTM, November 1998
  2. 7.0.699 - SP1
  3. 7.0.842 - SP2
  4. 7.0.961 - SP3
  5. 7.0.1063 - SP4
4 questions
8
votes
1 answer

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 need the tables -- no views or stored procedures.
xpda
  • 765
  • 1
  • 6
  • 8
1
vote
0 answers

Identify SQL Server Version in TSQL

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.
Sebastian
  • 113
  • 2
1
vote
0 answers

"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'm using Microsoft SQL Server 7.0. This is a…
Lynx Kepler
  • 191
  • 4
  • 13
0
votes
1 answer

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 SQL authentication on the local machine. I can…
Eli
  • 480
  • 5
  • 9