Friday, March 23, 2012

Query for service pack version

How can I get the service pack version from SQL2000?
thanksTry:
select serverproperty ('ProductLevel')
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Jeff Kendrick" <Jeff Kendrick@.discussions.microsoft.com> wrote in message
news:EBB3CE7F-8C53-4016-BF83-3E8066BA3755@.microsoft.com...
How can I get the service pack version from SQL2000?
thankssql

No comments:

Post a Comment