Monday, November 26, 2012

Simple Query to Get All Details About SQL Server

Its is very popular and short command for getting the version details by running the query SELECT @@version but if you need further details with different tabs for each version, edition, service pack number, and etc. Please find below the most useful query for any one who is working on SQL server.

SELECT
      SERVERPROPERTY('Productversion') as 'Product Version',
      SERVERPROPERTY('Productlevel') as 'Product Level',
      SERVERPROPERTY('Edition') as 'Product Edition',
      SERVERPROPERTY('Buildclrversion') as 'CLR Version',
      SERVERPROPERTY('Collation') as 'Default Collation',
      SERVERPROPERTY('Instancename') as 'Instance',
      SERVERPROPERTY('lcid') as 'LCID',
      SERVERPROPERTY('servername') as 'Server Version'


How to get SQL Server Edition. How to get SQL Server Version. How to get SQL Server product edition. How to get SQL Server patch level. How to get SQL Server CLR Version. How to get SQL Server default collation. How to get SQL Server installed collation settings. How to get SQL Server server name. How to get SQL Server LCID. How to get SQL Server Instance Name. How to get SQL Server Serive pack number. How to get SQL Server Service Pack number. sql server 2012 version script. sql server 2012 TSQL. T-SQL. sql server 2008 R2. sql server 2012. sql server 2005. Get version details of multiple SQL server's

0 comments:

Post a Comment