Thanks for the syntax on those statements. If I built stored procedures for each of those statements, would I put them in MSDB?
What permissions/role would a user have to be to be able to execute those statements? Anything special, or would they just need execute permission on those procs?
Jim