* How to Check for SQL Logins, with NO Database Mapping

USE MASTER;
CREATE TABLE #dbusers (
sid VARBINARY(85))
EXEC sp_MSforeachdb
'insert #dbusers select sid from [?].sys.database_principals where type != ''R'''
SELECT name
FROM sys.server_principals
WHERE sid IN (SELECT sid
FROM sys.server_principals
WHERE TYPE != 'R'
AND name NOT LIKE ('##%##')
EXCEPT
SELECT DISTINCT sid
FROM #dbusers)
GO
DROP TABLE #dbusers

* When did CheckDB last run?

Use Testdb

GO
DBCC TRACEON(3604)
DBCC DBINFO
DBCC TRACEOFF(3604)

* T-SQL Query to find list of Instances Installed on a machine

DECLARE @GetInstances TABLE 
( Value nvarchar(100), 
 InstanceNames nvarchar(100), 
 Data nvarchar(100))  
Insert into @GetInstances 
EXECUTE xp_regread 
  @rootkey = 'HKEY_LOCAL_MACHINE', 
  @key = 'SOFTWARE\Microsoft\Microsoft SQL Server', 
  @value_name = 'InstalledInstances' 
 
Select InstanceNames from @GetInstances