Post reply

Use Powershell to delete a logon trigger that has locked down a DB?

  • July 12, 2012 at 3:11 am

    #264200

    Hi,

    Is it possible to use Powershell to delete a logon trigger that has locked down a DB?

    Thanks, Phil

  • July 12, 2012 at 3:30 am

    #1511937

    I would think so, but IIRC, you need to log in with the DAC to avoid these triggers and disable them.

  • July 13, 2012 at 5:16 am

    #1512463

    Thanks, I'll test it out. We had an incident the other day, and I thought it might be best to keep a script on hand just in case someone else tries it on our Prod Monitoring server 😉 .

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply