I'm new to sql 2000. I just didn't an installation. I want to apply the lastest service pack. which one should i install? sql2kasp3.exe, sql2desksp3.exe or sql2sp3.exe. I install this on a 2000 server. thanks
sql2sp3.exe is the service pack for the Server.
sql2kasp3.exe is the service pack for the analyse tools.
sql2desksp3.exe is the service pack for the desktop edition.
You want sql2sp3.exe. Be use that you use sp3a not sp3. There are some fixes in 3a that arn't in 3.
Query Analyzer is an easier tool to use. You should find it under Start/Programs/Microsoft SQL Server/
If you want to use osql add the -c switch. This allows you to use a character to tell osql that you are at the end of the command. Try using "osql -u sa -p -c ;".
Then run:
Code:
SELECT 'SQL Server '
+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '
+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('
+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'
The server I'm logged into at the member returns "SQL Server 8.00.818 - SP3 (Enterprise Edition)".
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.