Hi
Just a question ... how can I know wich is it the last service pack installe
d on my SQL Server?
Thanks so much!Issue this command:
select SERVERPROPERTY ( 'productlevel' )
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Han" <anonymous@.discussions.microsoft.com> wrote in message
news:1106BB12-1251-4E6A-A46C-C424D002A2BA@.microsoft.com...
> Hi
> Just a question ... how can I know wich is it the last service pack
installed on my SQL Server?
> Thanks so much!
>|||http://www.aspfaq.com/show.asp?id=2160
"Han" <anonymous@.discussions.microsoft.com> wrote in message
news:1106BB12-1251-4E6A-A46C-C424D002A2BA@.microsoft.com...
> Hi
> Just a question ... how can I know wich is it the last service pack
installed on my SQL Server?
> Thanks so much!
>|||In a sql file:
exec master..xp_msver
Run that in Query Analyzer. But you have to go to Microsoft and match =
up the version you get with the corresponding version for the Service =
Pack. In SQL 2000 anyway.=20
--=20
George Hester
__________________________________
"Han" <anonymous@.discussions.microsoft.com> wrote in message =
news:1106BB12-1251-4E6A-A46C-C424D002A2BA@.microsoft.com...
> Hi
>=20
> Just a question ... how can I know wich is it the last service pack =
installed on my SQL Server?
>=20
> Thanks so much!
>
1 comment:
This is my Good luck that I found your post which is according to my search and topic, I think you are a great blogger, thanks for helping me out from my problem..
1998 Chrysler LHS AC Compressor
Post a Comment