Sunday, March 25, 2012

@@BVersion.... Edition

How to findout the edition of SQL Server? like standard, enterprise...
select @.@.version gives that information?
I am using SQL 2K.
Thanks,
SmithHello
select serverproperty('Edition') will provide that information.
Check books on line for serverproperty().
select @.@.version will give the build version. SQLSecurity WebSite has a SQL
Server version database -
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org
"Allen Smith" wrote:

> How to findout the edition of SQL Server? like standard, enterprise...
> select @.@.version gives that information?
> I am using SQL 2K.
> Thanks,
> Smith
>
>|||YOu are absoletely rigth.
Select @.@.Version
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Allen Smith" <ASmith_Forest@.hotmail.com> schrieb im Newsbeitrag
news:OXp78GGbFHA.348@.TK2MSFTNGP14.phx.gbl...
> How to findout the edition of SQL Server? like standard, enterprise...
> select @.@.version gives that information?
> I am using SQL 2K.
> Thanks,
> Smith
>
>|||Allen Smith wrote:
> How to findout the edition of SQL Server? like standard, enterprise...
> select @.@.version gives that information?
Though SELECT @.@.VERSION gives a long string that contains the edition
info too, you will have to copy it and paste it into the editor area to
really see that long string!
Instead, the SELECT SERVERPROPERTY('Edition') gives you just what you
wanted!|||Sarah wrote:
> Allen Smith wrote:
> Though SELECT @.@.VERSION gives a long string that contains the edition
> info too, you will have to copy it and paste it into the editor area
> to really see that long string!
> Instead, the SELECT SERVERPROPERTY('Edition') gives you just what you
> wanted!
In my case it's not a problem to see the string you get with SELECT
@.@.VERSION. If you just "expand" the result column you can scroll back and
forth to see it.
Regards
Steen

No comments:

Post a Comment