var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to dispaly extended stored procedures for users
I need to prepare report which will show all extended stored procedures and all users who can execute it. Do anybody have idea whoud could be the best solution for that ?
I run sp_helprotect but it display all procedures with grantee. However I can't filter the results.
I also run 'select name from sysobjects where name like 'xp_%' order by 1' and I get list of extended stored procedures only but still without mapping to the users usage.
I need to show only xp_* + users access.