August 2, 2010 at 1:33 am
Hello
We are having lots of SQL Server for Test and Production.
Actually i need following infromation from the servers.
If you help me out with that it should be really great.
1)We need to know what jobs are running on what servers and what those jobs do. We’re going to need to look into all the jobs on all the servers and determine what they are doing and whether they are still relevant.
2)same for security. Who has permissions to do what on what servers.
Thanks a lot
August 2, 2010 at 3:00 am
For finding job details you may find this script useful.
Running sp_helplogins will give the details of all the logins on an instance.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 6:24 am
Query of below can help you on direction of security
set nocount on
go
--- 1. Details about the Fixed Server Roles
PRINT '1. Details about the Fixed Server Roles'
GO
sp_helpsrvrolemember
-----2. Details about the Database Fixed Role Member
PRINT 'Details about the Database Fixed Roles '
go
exec sp_MSforeachdb @command1='SELECT ''The Database Name is ''+''?''',@command2 ='sp_helprolemember'
go
----- Details about the Object level
PRINT '3. Details about the Object level '
go
exec sp_MSforeachdb @command1='SELECT ''The Database Name is ''+''?''',@command2 ='sp_helprotect'
go
set nocount off
go
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply