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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-19 : 08:30:03
|
| Rodrigo Ornelas writes "How Can I see the sevice pack that is installed on SQL?wich is the stored procedure that I can use to see it?Thanks" |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-19 : 08:35:41
|
| In SQL 2000SELECT SERVERPROPERTY('ProductLevel')Raymond |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-19 : 12:27:48
|
| Also,SELECT @@VERSIONTara |
|
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-22 : 04:02:43
|
| The problem I've got with @@Version Tara is that unless you can remember or look up the serial number it's not much use for identifying the Service Pack. It's always seemed funny to me that they name the OS Service Pack but choose something cryptic like 8.00.760 for the SQL Server Service Pack :)Raymond |
|
|
|
|
|
|
doubt