0

I'm having issues with SQLServer 2008 where a Server level triggered was not dropped correctly.

Articles on the web recommend dropping them through the DAC.

However, the DAC is disabled by default on Clustered environments.

How do I enable the DAC bearing in mind that I can no longer connect to the SQLServer 2008 instance in any other way.

cheers

andy

andy
  • 8,775
  • 13
  • 77
  • 122

1 Answers1

1

According to this article the only other alternative to drop these triggers is to stop your server and restart it using the minimal configuration mode. You can obviously then enable the DAC.

Martin Smith
  • 438,706
  • 87
  • 741
  • 845