Posted by SQL Enthusiast
Article by our editor
In most situations it is sufficient to grant a user 'EXECUTE' rights to a stored procedure in order to run it, however if the stored procedure contains dynamic SQL an error can occur even if the user has sufficient rights to run the stored procedure. Fortunately we can use "Execute As" to resolve this.
Comments • Read full article »
As a DBA it’s important to quickly identify any issues with SQL Server Agent jobs. This article includes a number of scripts which make it easy to identify which jobs have failed and which are still running as well as generating a history of when each job ran.
Comments (32) • Read full article »
More SQL questions »