Ask for version of Service Pack of SQL Server 2000?

Dear All,
How do I know the version of SP that has been installed in my SQL Server
2000?
Thanks
Robert LieTry:
SELECT SERVERPROPERTY('ProductLevel')
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:%23AVYZ%23EUFHA.2964@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> How do I know the version of SP that has been installed in my SQL Server
> 2000?
> Thanks
> Robert Lie|||http://www.aspfaq.com/2160
http://www.aspfaq.com/sql2000Builds.asp
--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:%23AVYZ%23EUFHA.2964@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> How do I know the version of SP that has been installed in my SQL Server
> 2000?
> Thanks
> Robert Lie

Ask for version of Service Pack of SQL Server 2000?

Dear All,
How do I know the version of SP that has been installed in my SQL Server
2000?
Thanks
Robert LieTry:
SELECT SERVERPROPERTY('ProductLevel')
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:%23AVYZ%23EUFHA.2964@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> How do I know the version of SP that has been installed in my SQL Server
> 2000?
> Thanks
> Robert Lie|||http://www.aspfaq.com/2160
http://www.aspfaq.com/sql2000Builds.asp
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:%23AVYZ%23EUFHA.2964@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> How do I know the version of SP that has been installed in my SQL Server
> 2000?
> Thanks
> Robert Lie

Ask for version of Service Pack of SQL Server 2000?

Dear All,
How do I know the version of SP that has been installed in my SQL Server
2000?
Thanks
Robert Lie
Try:
SELECT SERVERPROPERTY('ProductLevel')
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:%23AVYZ%23EUFHA.2964@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> How do I know the version of SP that has been installed in my SQL Server
> 2000?
> Thanks
> Robert Lie
|||http://www.aspfaq.com/2160
http://www.aspfaq.com/sql2000Builds.asp
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:%23AVYZ%23EUFHA.2964@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> How do I know the version of SP that has been installed in my SQL Server
> 2000?
> Thanks
> Robert Lie