How to Determine Service Pack

This question is for both SQL Server 2000 and 2005
How can I tell what service pack have been applied to a SQL Server instance?
Thanks
TTry:
select serverproperty ('ProductLevel')
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
news:eJ8SoxrOIHA.1204@.TK2MSFTNGP03.phx.gbl...
This question is for both SQL Server 2000 and 2005
How can I tell what service pack have been applied to a SQL Server instance?
Thanks
T|||That worked just fine.
Thanks so much
T
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ORXyO8rOIHA.5160@.TK2MSFTNGP05.phx.gbl...
> Try:
> select serverproperty ('ProductLevel')
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
> news:eJ8SoxrOIHA.1204@.TK2MSFTNGP03.phx.gbl...
> This question is for both SQL Server 2000 and 2005
> How can I tell what service pack have been applied to a SQL Server
> instance?
> Thanks
> T
>
>

How to Determine Service Pack

This question is for both SQL Server 2000 and 2005
How can I tell what service pack have been applied to a SQL Server instance?
Thanks
TTry:
select serverproperty ('ProductLevel')
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
news:eJ8SoxrOIHA.1204@.TK2MSFTNGP03.phx.gbl...
This question is for both SQL Server 2000 and 2005
How can I tell what service pack have been applied to a SQL Server instance?
Thanks
T|||That worked just fine.
Thanks so much
T
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ORXyO8rOIHA.5160@.TK2MSFTNGP05.phx.gbl...
> Try:
> select serverproperty ('ProductLevel')
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
> news:eJ8SoxrOIHA.1204@.TK2MSFTNGP03.phx.gbl...
> This question is for both SQL Server 2000 and 2005
> How can I tell what service pack have been applied to a SQL Server
> instance?
> Thanks
> T
>
>

How to Determine Service Pack

This question is for both SQL Server 2000 and 2005
How can I tell what service pack have been applied to a SQL Server instance?
Thanks
T
Try:
select serverproperty ('ProductLevel')
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
news:eJ8SoxrOIHA.1204@.TK2MSFTNGP03.phx.gbl...
This question is for both SQL Server 2000 and 2005
How can I tell what service pack have been applied to a SQL Server instance?
Thanks
T
|||That worked just fine.
Thanks so much
T
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ORXyO8rOIHA.5160@.TK2MSFTNGP05.phx.gbl...
> Try:
> select serverproperty ('ProductLevel')
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
> news:eJ8SoxrOIHA.1204@.TK2MSFTNGP03.phx.gbl...
> This question is for both SQL Server 2000 and 2005
> How can I tell what service pack have been applied to a SQL Server
> instance?
> Thanks
> T
>
>