Thanks Gail! Would dynamic SQL be the only way? Our shop has an anti-dynamic-sql policy in place due to security!

Thanks for the start in the right direction!

Is there a way to do it through powershell though? The reason i'm asking is that i'd like to have powershell enumerate through a text list of specific SPs...

Article? Yes, please! Seems like there's a lots of information to glean from the shredded xml!

Awesome script, much appreciated. =)

When i have this in the command box:

C:\WINDOWS\system32\WindowsPowerShell\v1.0\powershell.exe -file h:\failedsqljobs_email.ps1

i end up getting an error of:

The term '-f' is not recognized as a cmdlet, function, operable program, or scr...

What would some of the risks be behind replication?  Would it be easier to use triggers to update our tables?

Hi there!  Ok - to clarify, when our developer right clicks into a stored procedure's properties and goes into the permissions, there is a list of users/roles who have execute on...

Thanks! So it's not possible to script out a stored procedure in management studio that includes all the permissions on that stored proc?

One more question - is there a way for me to roll out management studio and only management studio without the other client tools?? 

Alright, that's cool that a buncha y'all already have it up and running and that there are no HUGE issues.  We'll be rolling out mgmt studio to a couple of...

Thanks - are they any issues from a developer's perspective? 

Wow.   Thanks!

Hi Lynn, good point - the @options varchar(255).  Will look into it, thanks for your help!

Thank you all for your help.   The networking team in charge of the servers that host the registered [database] servers complain that their security log files...