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 |
|
vics
Starting Member
7 Posts |
 Posted - 2002-01-03 : 14:51:28
|
| Gang thanks for input relative to detaching/ attach of log files - ( high fives to Sarah & Ilya ) - worked great!Question # 2 on this inherited database: How do I determine if SP2's installed?Thanks in advance ! - Vic |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-01-03 : 15:44:41
|
| If you are on SQL2k, look up SERVERPROPERTY function in BOL. If you are on SQL7, check the value of @@VERSION variable:7.00.623 - Base SQL Server 7.0 7.00.699 - SP1 7.00.842 - SP2 7.00.961 - SP3Edited by - izaltsman on 01/03/2002 15:46:47 |
 |
|
|
|
|
|
Service pack or not?