SQL SCRIPT to grant DBC_Execute to all user defined Stored Procs.This SQL SCRIPT is handy specially after Stored Procs are DROPPED & CREATED; often users dont mention the SQL to grant DBC_Execute permission to the Store Procs.This SQL SCRIPT will grant execute permission to DBC_Execute for all user defined Stored Procs. The SCRIPT can be […]
2004-10-03
175 reads
The SQL 7.0 Query for listing of all users tables with owner, no of rows and Date/Time created is as follows
2002-06-06
277 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I love database audits. They are simple, easy to use, effective, not overly resource...
Hi, I am having error in creating AG Group Listener. We finally try to...
Hello, Since Operators are not supported in SQL MI, how do you set up...
If I run my PS script with PS as an ADMIN interactively it runs...
Ask SSC