sql server 2000 /version info - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

sql server 2000 /version info

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-02-23 : 09:10:21

veliana writes "How to identify SQL Server service pack version, installed updates and paches?"

bakerjon
Posting Yak Master

145 Posts

Posted - 2006-02-23 : 09:25:00

Try this link. http://vyaskn.tripod.com/sqlsps.htm

Essentially, you type in SELECT @@VERSION in Query Analyzer and it tells you a bunch of numbers. Then you lookup with service pack is associated with those numbers.

Jon
When your forehead becomes flat, find another wall to hit it against.

http://www.sqljunkies.com/weblog/outerjoin

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-23 : 09:34:50

Note that the service pack information returned by select @@version is of Operating system in which SQL Server is installed.

To know SQL Server's Service Pack

Select SERVERPROPERTY ('productlevel') as SP

Madhivanan

Failing to plan is Planning to fail

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-02-23 : 11:06:50

there is also the SQL Server version database over at sqlsecurity.com

http://sqlsecurity.com/DesktopDefault.aspx?tabid=37

-ec

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2006-02-23 : 11:46:53

Funnily enough, you can also find it at Microsoft..

http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources