Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
valliyil
Starting Member
8 Posts |
 Posted - 2005-03-29 : 04:19:39
|
| I Installed SQL Server 2000 Standard Edition on Windows 2003 server Operating System. Also run the Service pack 3a. When I tried to see the version of sqlserver using 'select @@version', In the result I am not getting which service pack is installed. only showing below in result panMicrosoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: ) please help me. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-29 : 05:59:06
|
| That's the normal output of SELECT @@version. The last 3 digits of the version number will tell you what service pack is installed:http://support.microsoft.com/kb/321185 |
 |
|
|
valliyil
Starting Member
8 Posts |
Posted - 2005-03-29 : 23:21:51
|
| Yes I found the solution. thanks for the reply. by version number I indentify the service pack installed. |
|
|
|
|
|
|
Service pack 3a on sqlserver 2000 standard edition