-
Service Packs in SQL 7
I realize that this is probably a very simple question, but how do i determine what service pack is installed on an SQL 7.0 server?
-
Service Packs in SQL 7 (reply)
Do a select @@Version in ISQL, it will tell you 7.0.XXX (XXX) is the version number. It also tells you what NT version and level your at.
------------
Ivan at 1/8/2002 9:11:21 AM
I realize that this is probably a very simple question, but how do i determine what service pack is installed on an SQL 7.0 server?
-
Service Packs in SQL 7 (reply)
SQL Server 7.0 - Service Pack Versions
@@VERSION SQL Server Version
7.00.623 Original SQL Server 7.0 or MSDE 1.0 release
7.00.699 Database Components SP1
7.00.842 Database Components SP2
7.00.961 Database Components SP3
SQL Server 7.0 OLAP - Service Pack Versions
Help About SQL Server OLAP Services Version
7.0.1073 Original SQL Server 7.0 OLAP Services release
7.0.1295 OLAP Services SP1
7.0.1458 OLAP Services SP2
7.0.1508 OLAP Services SP3
------------
Mel at 1/8/2002 10:29:57 AM
Do a select @@Version in ISQL, it will tell you 7.0.XXX (XXX) is the version number. It also tells you what NT version and level your at.
------------
Ivan at 1/8/2002 9:11:21 AM
I realize that this is probably a very simple question, but how do i determine what service pack is installed on an SQL 7.0 server?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|