Thanks I'll check it out

-WM

That's what I was looking for thanks

-WM

thanks

In addition to that are there any other functions that contain this info?

-WM

Create a sql login.

Make the owner of the jobs that need to be editied by developers the sql login.

If someone needs to go in an edit a job or make other...

DMV 

sys.server_principals

-WM

thanks

-WM

Thanks

-WM

Worked perfectly

thanks for you help guys

Creating the procedure and using xp_cmdshell worked perfect.

Thanks again

-WM

DBA

I have the same error (SQL Server 2005 SP1.) restarting the agent stops the error for a while but it always starts up again. Anyone find any solutions??

-WM 

DBA 

Security tab  --> Logins --> right click name to modify select properties --> securables tab --> Click add --> Select the server you want to add the permissions to. The...

Put the query in DTA and run it. Look at the recommendations and test to c if any of them will work.

-WM

I've been using Dm from Idea for about 6 months. It seems to provide the information your looking for

-WM

DBA

Thanks for your help

-WM

Sill need help with this...

-WM