Powertips

You can check the sql server version by using the SERVERPROPERTY function.

Exampe:

SELECT
SERVERPROPERTY(‘ProductVersion’) AS ProductVersion,
SERVERPROPERTY(‘ProductLevel’) AS ProductLevel,
SERVERPROPERTY(‘Edition’) AS Edition,
SERVERPROPERTY(‘EngineEdition’) AS EngineEdition;
GO

Read More…

ServerProperty function, sql server, version

This entry was posted on Wednesday, May 5th, 2010 at 3:07 pm and is filed under Database, MS SQL Server, SQL Server 2008. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.