/* 
Created by : Hemantgiri S. Goswami
Version: 1.0
Date: 19/March/2009

*/
-- Displays Collatioln Informatioln
select cast(serverproperty('Collation') as varchar(25)) as 'Collation'
go
-- Displays which SQL Server Edition is installed
select cast(serverproperty('Edition') as varchar(25)) as 'Edition'
go
-- This will Displays SQL Server Engine Edition, Personal/MSDE, Enterprise,Developer,Standard it returns int value
select cast(serverproperty('EngineEdition') as varchar(25)) as 'Engine Edition'
go
-- It will displays name of Instance(s)
select cast(serverproperty('InstanceName') as varchar(25)) as 'InstanceName'
go
-- This will return 1 if Server is enabled/installed for Cluster
select cast(serverproperty('IsClustered') as varchar(25)) as 'isClustered'
go
-- If Full Text Catalog is enabled / installed it will return 1
select cast(serverproperty('IsFullTextInstalled') as varchar(25)) 'isFullTextInstalled'
go
-- It will shows the Authentication Mode for server, it will return 1 forintegrated Security 
--and  0 for Not Integrated Security
select cast(serverproperty('IsIntegratedSecurityOnly') as varchar(25)) as 'Authentication Mode'
go
-- Will return 1 if server is in single user mode 
select cast(serverproperty('IsSingleUser') as varchar(25))  as 'Single User Mode' 
go
-- This will return true if database can be retored without disturbing replicated database at distribution or subscription
select cast(serverproperty('IsSyncWithBackup') as varchar(25))  as 'Can Sync with Repl' 
go
-- It will display the Licence Type of Sever wether it is Per Seat or Per Processor
select cast(serverproperty('LicenseType') as varchar(25))  as 'Licence Type'
go
-- This will retrun name of machine on which sql server is installed
select cast(serverproperty('MachineName') as varchar(25)) as 'Machine Name' 
go
-- Returns Number of Licences for Server
select cast(serverproperty('NumLicenses') as varchar(25)) as 'Number of Licence' 
go
-- will help identifying which sqlservr.exe belongs to which instance
select cast(serverproperty('ProcessID') as varchar(25))  as 'Process ID'
go
-- This will return BUILD Version of SQL Server Product in Integer
select cast(serverproperty('ProductVersion') as varchar(25)) as 'Product Verstion'
go
-- This will gives information for Product Level (RTM/SP)
select cast(serverproperty('ProductLevel') as varchar(25)) as 'Product Level'
go
-- This will gives you name of SQL Server 
select cast(serverproperty('ServerName') as varchar(25)) as 'SQLServerName'
go