| Author |
Whether Service Pack Installed on SQL server 2005
|
|
| sesciber 2006-12-13, 12:13 am |
| 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?
| |
| Hari Prasad 2006-12-13, 12:13 am |
| 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...
>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?
>
| |
| sesciber 2006-12-13, 12:13 am |
| It 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...
>
>
>
|
|
|
|