Hello Fazal,

Thanks for sharing nice thing here.

We can have more information about servers with following scripts as well,

[CODE]

EXEC [DBO].[spserverinfo]

SELECT CONVERT(sysname, SERVERPROPERTY('servername'));

SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion, SERVERPROPERTY('ProductLevel') AS ProductLevel, SERVERPROPERTY('Edition') AS Edition, SERVERPROPERTY('EngineEdition') AS EngineEdition;

[/CODE]

Thank you paresh for sharing very useful information.

I would use the method suggested by Paresh, i.e. using SERVERPROPERTY() instead of @@VERSION.

Also, notice that @@VERSION returns an additional piece of information - the software platform that SQL Server is running on.

Thanks & Regards,

Nakul Vachhrajani

http://beyondrelational.com/blogs/nakul/default.aspx

Be courteous. Drive responsibly.