This Code Helps you to GRANT Various Permissions to Specific TYPE Objects in a Database.
you can expand this to include other Databases or all databases in a SQl Server instance.
Mani Singh,
2008-08-01 (first published: 2008-06-08)
This Code Helps you to GRANT Various Permissions to Specific TYPE Objects in a Database.
you can expand this to include other Databases or all databases in a SQl Server instance.
Select 'GRANT EXECUTE ON '+name+' TO Maninder' from sysobjects Where type='P' and Category='0'
2008-06-08
1,825 reads
Search for String Occurence with this script in your stored procedures.
2011-10-20 (first published: 2008-06-08)
5,076 reads
2008-07-29 (first published: 2008-06-08)
1,250 reads