which version

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex - 19 Nov 2006 22:06 GMT

How do I tell which version of SQL and level. of patching is installed
tks

A

Reply to this Message

emartinez.pr1@gmail.com - 20 Nov 2006 01:26 GMT

If you are running SQL Server 2000, you should be able to right-click
the server in Enterprise Manager and go to properties. The main tab
will show the version and the service pack. If there is a service pack
it will appear next to the version in parenthesis [i.e., 8.0.2094
(SP4)]. Also, I believe that there is a system stored procedure that
should be able to give the same information; though I don't remember
the exact name (xp_msver or something similar). Hope this helps.

Regards,

Enrique Martinez
Sr. SQL Server DBA/Developer
emartinez.pr1@gmail.com

> How do I tell which version of SQL and level. of patching is installed
> tks
>
> A

Reply to this Message

Andy Reilly - 29 Nov 2006 14:23 GMT

It's @@Version

> If you are running SQL Server 2000, you should be able to right-click
> the server in Enterprise Manager and go to properties. The main tab
[quoted text clipped - 14 lines]
>>
>> A

Reply to this Message