Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Which service pack is installed

0 views
Skip to first unread message

Roy Goldhammer

unread,
Aug 29, 2010, 6:50:37 AM8/29/10
to
How can i know on sql server which service pack is installed?


Erland Sommarskog

unread,
Aug 29, 2010, 7:56:39 AM8/29/10
to
Roy Goldhammer (ro...@yahoo.com) writes:
> How can i know on sql server which service pack is installed?

Check out serverproperty() in Books Online. Or look at the status bar in
SQL Server Management Studio!


--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Roy Goldhammer

unread,
Aug 31, 2010, 2:44:04 PM8/31/10
to
Thans Erland
"Erland Sommarskog" <esq...@sommarskog.se> wrote in message
news:Xns9DE38DD9A...@127.0.0.1...
0 new messages