Script to Generate Execution Permission to all Sprocs
This script generates script to give permissions to Particular user(s) to give exectue permission. This can be changed to give permission to tables, views also.
2002-05-09
204 reads
Blogs
Function Vs. Performance
Recently I was looking through DBA.StackExchange when I saw a pretty simple question that...
Daily Coping 3 Oct 2022
By Steve Jones
Today’s coping tip is to write down three things you appreciate about yourself. I...
Scary Scalar Functions - Part Four: Your Environment
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
Forums
subscriber part of ALWAYSON
Hi. Publisher stop sending transaction to AOAG primary replica whenever AG failover. It seems...
SQL Server Licensing Question
I'm in the process of replacing a sql server 2012 with 2019. How do...
SSRS Reporting
Anyone can give me a sample program on how to pass parameters from SSRS...
Ask SSC