administration

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)

2020-09-24

1,456 reads

Blogs

Rotating a Certificate Used by TDE

By

In terms of encryption, Key Rotation is the process of replacing your encryption keys...

Daily Coping 3 Feb 2023

By

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Read the latest Blogs

Forums

Ownership chaining

By Duncan Lawrence

Hi, I have four views on one database to which one sql authenticated user...

Schedule Jobs on a Clustered SQL Server

By Prasad Chava

Comments posted to this topic are about the item Schedule Jobs on a Clustered...

Encrypting the Database Encryption Key

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Encrypting the Database Encryption Key

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers