Rudy Panigas

SQL Server DBA since SQL 7.0
Production DBA with experience on version SQL 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, Disaster Recovery, Security

DAC - What to Execute when Connected?

by Rudy Panigas

SQLServerCentral.com

DAC

SQL Server Issues? Connect with Dedicated Administrator Connection (DAC), then what? Execute this stored procedure to get some understanding on what is going on in the SQL server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(30)

Log in or register to rate

You rated this post out of 5. Change rating

2008-12-19

6,232 reads

Discuss

Blogs

A New Word: Dolorblindness

dolorblindness – n. the frustration that you’ll never be able to understand another person’s...

Claude Code Helps Analyze Test Data Manager Log Files

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

PowerPoint to HTML with Claude AI

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

Read the latest Blogs

Forums

Optimism Without Illusion or Why AI Needs Blunt Technologists

Comments posted to this topic are about the item Optimism Without Illusion or Why...

SSIS with VS2022 64/32 issue with Excel files

Hi all, I'm trying to do classic scenario for loading multiple Excel files into...

Case part is sloooooow

Hi So the case statement is slowing this down - but for the life...

Visit the forum

Question of the Day

The String Distance I

In SQL Server 2025, what is returned by this code:

SELECT EDIT_DISTANCE('tim', 'tom')

Assume preview features are enabled.

See possible answers