Technical Article

SQL SCRIPT to grant DBC_Execute to all user SP

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

Blogs

Daily Coping 29 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 28 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Creating a Database Audit Specification can create new users & schemas in the background

By

I love database audits. They are simple, easy to use, effective, not overly resource...

Read the latest Blogs

Forums

AOAG Listener Error:Kerberos Status is showing: Incorrect username and Password

By Shashihemanth

Hi, I am having error in creating AG Group Listener. We finally try to...

How to set up Replication Alerts in SQL MI

By DanielP

Hello, Since Operators are not supported in SQL MI, how do you set up...

Attempting to run PS / DBA tools script as a SQL Agent job

By Summer90

If I run my PS script with PS as an ADMIN interactively it runs...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers