Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
Whether Service Pack Installed on SQL server 2005I would like to find out whether service pack has been installed on SQL server 2005 or not. Any T-SQL or sp_* command can find it?
Post Follow-up to this message
Re: Whether Service Pack Installed on SQL server 2005Hello,
Execute the below command in Query Text window of SQL Server Management
Studio...
select serverproperty('prod
uctlevel')
Thanks
Hari
"sesciber" < sesciber@discussions
.microsoft.com> wrote in message
news:B2AF620E-4A50-4C4A-BB8C- 3402B54E6C59@microso
ft.com...
>I would like to find out whether service pack has been installed on SQL
> server 2005 or not. Any T-SQL or sp_* command can find it?
>
Post Follow-up to this message Re: Whether Service Pack Installed on SQL server 2005It is working now and thanks for your help.
"Hari Prasad" wrote:
> Hello,
>
> Execute the below command in Query Text window of SQL Server Management
> Studio...
>
> select serverproperty('prod
uctlevel')
>
> Thanks
>
> Hari
>
> "sesciber" < sesciber@discussions
.microsoft.com> wrote in message
> news:B2AF620E-4A50-4C4A-BB8C- 3402B54E6C59@microso
ft.com...
>
>
>
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
