T-SQL Stored Procedure to Grant Permissions on Stored Proc Objects

In today’s universe of multi-tiered distributed processing, VMs, etc. you may need a quick and easy way to generate and migrate T-SQL scripts capable of setting up the necessary permissions so that an enterprise service account will be able to execute them. In this example, I am looking for all NON-Microsoft-Shipped (IsMSShipped) stored procedure (sproc) [...]

Read Full Post »