Hi,
I need to know the way to find my sql server's product
version.
Thanks in advance.
Deda ZhengHi,
In query analyzer run this query
select @.@.version
Cheers,
Shiva.
Chennai.
"dzheng" <dzheng@.weather.com> wrote in message
news:091501c3455c$386e3400$a001280a@.phx.gbl...
> Hi,
> I need to know the way to find my sql server's product
> version.
> Thanks in advance.
> Deda Zheng
>|||If you are running SQL Server 2000 you can also use the SERVERPROPERTY
function:
SELECT SERVERPROPERTY('Edition')
SELECT SERVERPROPERTY('ProductVersion')
SELECT SERVERPROPERTY('ProductLevel')
--
Alan Brewer [MSFT]
Lead Technical Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment