Show Database Information

You can use the following SQL query in SSMS to show information about the SQL Server instance and the current Winsby Group Product database where the query is run.

SELECT DB_NAME() as [DatabaseName], *,
    @@SERVERNAME AS [ServerName], 
    @@SERVICENAME AS [Instance], 
	(SELECT compatibility_level FROM sys.databases WHERE database_id = DB_ID()) as CompatibilityLevel
FROM [version]