October 10, 2001 at 12:48 pm
Does anyone know of a stored procedure or glkobal variable that gets an SQL Server's current Service Pack?
October 10, 2001 at 2:41 pm
select @@version will get you the information you are looking for.
Versions are as follows
SQL Server NoSP SP1 SP2 SP3 SP4 SP5 SP5a
SQL Server 6.0 6.00.121 6.00.124 6.00.139 6.00.151
SQL Server 6.5 6.50.201 6.50.213 6.50.240 6.50.258 6.50.281 6.50.415 6.50.416
SQL Server 7.0 7.00.623 7.00.699 7.00.842 7.00.961
SQL Server 2000 8.00.194 8.00.384
This may look funky so, if you want it in excel email me and I will send it.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 11, 2001 at 8:29 am
When I selected @@version I got this:
Microsoft SQL Server 7.00 - 7.00.961 (Intel X86)
Oct 24 2000 18:39:12
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)
Does that mean I have service pack 4? Is there an SP 4 for SQL 7?
October 11, 2001 at 8:35 am
Oh I get it now. I have SP 3, thanks for the help, you are the man. I am off to thank Microsoft for not making this conversion.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply