Thursday, January 26, 2012

To know the databse version in SQl Server

To know the version of the Database by query:


Select @@version as x


another query for a more specific results, we can execute

Select SERVERPROPERTY('productversion') As [Version],
SERVERPROPERTY('productlevel') As [Level],
SERVERPROPERTY('edition') As [Edition]

No comments: