#list sql server objects

List SQL Server Objects

To list out all Databases in SQL Server run the following query under master: SELECT name FROM master.dbo.sysdatabases To list out all SQL Server Jobs with Job Owner details use: SELECT s.name AS JobName, l.name AS JobOwner FROM msdb..sysjobs s LEFT JOIN master.sys.syslogins l ON s.owner_sid = l.sid WHERE l.name IS NOT NULL ORDER by l.name To list out all SQL Server Logins use: select…