StevRSA


Technical Article

Remove Exec Permissions To Extended Stored Procs

I created this script to simplify the process of restricting access to high risk extended stored procedures. It will find any user or role which has execute permissions on any of the stored procedures in the "#High_Risk_Stored_Procs" temp table and will generate the relevant revoke statements to remove those permissions.The current list of stored procedures […]

(1)

You rated this post out of 5. Change rating

2006-11-27 (first published: )

667 reads

Blogs

PowerPoint to HTML with Claude AI

By

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Monday Monitor Tips: SQL Auditing Preview

By

One of the features we advocates have been advocating for is a better way...

Read the latest Blogs

Forums

Form W-4 Updates 2026: What Employers and Employees Need to Know

By Supreme Trainer

Keeping up with Form W-4 updates doesn’t have to be complicated. In this practical...

Creating JSON I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON I

Visit the forum

Question of the Day

Creating JSON I

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( 'City':'Denver')
GO

See possible answers