DMV

Technical Article

Execute on DMVs without user having View Server State

  • Script

Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]

5 (1)

You rated this post out of 5. Change rating

2020-09-24

2,174 reads

Blogs

How to: Regain SysAdmin Access to a SQL Server Instance Without the SA Password

By

Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...

Secure Your SQL Estate: Best Practices for Azure SQL Security

By

The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...

The Book of Redgate: Meetings

By

I think we might have forgotten this a bit, but on one of the...

Read the latest Blogs

Forums

The Duplicate Cursor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Duplicate Cursor

Concerns over AI Chat Privacy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Concerns over AI Chat Privacy

Introduction of Azure SQL Hyperscale: Stairway to Azure SQL Hyperscale Level 1

By Chandan Shukla

Comments posted to this topic are about the item Introduction of Azure SQL Hyperscale:...

Visit the forum

Question of the Day

The Duplicate Cursor

Can I run this code:

DECLARE ANewTable CURSOR FOR 
SELECT * FROM ANewTable

See possible answers