-
List last running status of enabled jobs in Sql Server
Script below. This one works better for Sql Server 2000. I will do a version for Sql Server 2005, when I get a chance. It didn’t work very well on Sql Server 2005 because Ad Hoc Distributed Queries is disabled by default. set nocount on IF OBJECT_ID(‘tempdb..#TmpJobs’) IS NOT NULL DROP TABLE #TmpJobs SELECT *…
-
List all sa sysadmin in your Sql Server instances with Perl
This is mainly for my own reference. Save it as ListSysadmin.pl. Run ListSysadmin.pl SqlServerList.txt on command line. It lists all logins that has sa (sysadmin) rights on Sql Server instance, including individual domain members in a domain group that has sysadmin rights. SqlServerList.txt should be a text file, with each individual line contains a Sql…