cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
355
Views
0
Helpful
3
Replies

SQL service packet

admin_2
Level 3
Level 3

How can I find out which kind of SQL service packet has been applied on UNity server? I tried to find it from control panel, but nope. Thanks<br><br>

3 Replies 3

Not applicable

i am assuming by packet you mean service pack. (stretch?)

if iam correct then you can find this info
for 7.0
To determine which Service Pack level your SQL Server is currently running, execute the following statement from a Query Analyzer window:
You can determine what version SQL Server is running by running
Select @@version

@@Version is a system level variable that holds the current version. On my computer this returns

Microsoft SQL Server 2000 - 8.00.384 (Intel X86)
May 23 2001 00:02:52
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
The main version number is 8.00.384 which corresponds to SQL Server 2000 SP1. See below for a complete list of versions. It will also tell us the version of the operating system we're running. In this case I'm running Windows 2000 (aka NT 5.0) Service Pack 2. You can find this same information in Enterprise Manager by right clicking on a server and choosing Properties. The version information is displayed in the General tab.

This information is pulled from the system extended procedure xp_msver. You can call this stored procedure like

exec master..xp_msver
and it returns

Index Name Internal_Value Character_Value
------ -------------------------------- -------------- ------------------------------
1 ProductName NULL Microsoft SQL Server
2 ProductVersion 524288 8.00.384
3 Language 1033 English (United States)
4 Platform NULL NT INTEL X86
5 Comments NULL NT INTEL X86
6 CompanyName NULL Microsoft Corporation
7 FileDescription NULL SQL Server Windows NT
8 FileVersion NULL 2000.080.0384.00
9 InternalName NULL SQLSERVR
10 LegalCopyright NULL © 1988-2000 Microsoft ...
11 LegalTrademarks NULL Microsoft® is a registered ...
12 OriginalFilename NULL SQLSERVR.EXE
13 PrivateBuild NULL NULL
14 SpecialBuild 25165824 NULL
15 WindowsVersion 143851525 5.0 (2195)
16 ProcessorCount 1 1
17 ProcessorActiveMask 1 00000001
18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM
19 PhysicalMemory 255 255 (267902976)
20 Product ID NULL NULL
This is quite a bit of additional information. There really isn't anything exiciting in here that I can find but it's there if you need it.

SQL Server Versions
@@Version SQL Server Version Released
6.50.201 SQL Server 6.5 RTM
6.50.213 SQL Server 6.5 with Service Pack 1
6.50.240 SQL Server 6.5 with Service Pack 2
6.50.258 SQL Server 6.5 with Service Pack 3
6.50.281 SQL Server 6.5 with Service Pack 4
6.50.415 SQL Server 6.5 with Service Pack 5
6.50.416 SQL Server 6.5 with Service Pack 5a
7.00.623 SQL Server 7.0 / MSDE 1.0 RTM
7.00.699 SQL Server 7.0 SP1 July 1999
7.00.842 SQL Server 7.0 SP2 March 20th, 2000
7.00.961 SQL Server 7.0 SP3 December 15th, 2000
7.00.1063 sp4
8.00.194 SQL Server 2000 RTM
8.00.384 SQL Server 2000 SP1
8.00.534 SQL Server 2000 SP2





John Messina
Network Engineer
Crimson Technologies Inc.
jmessina@crimsoncti.com
http://www.crimsoncti.com

John, you wrote "To determine which Service Pack level your SQL Server is currently running, execute the following statement from a Query Analyzer window: "

What is a Query Analyzer Window? and how do I open it?

Thanks,

David Webster

dwebster@mnc.com

start>programs>Microsoft SQL Server>Query Analyzer

paste

Select @@version

into the window and click the execute arrow

then reference the above chart to determine the SP level

Alternatively, the easy way would be

start>programs>Microsoft SQL Server>Enterprise manager

right click server>properties (2000 only i think)