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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » Powershell » Use Powershell to delete a logon trigger that...

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

Rate Topic

Display Mode

Topic Options

Author

Message

phil.layzell

Posted Thursday, July 12, 2012 3:11 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:24 PM
Points: 49, Visits: 220

Hi,

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

Thanks, Phil

Post #1328741

Steve Jones - SSC Editor

Posted Thursday, July 12, 2012 3:30 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421, Visits: 13,734

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

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1328753

phil.layzell

Posted Friday, July 13, 2012 5:16 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:24 PM
Points: 49, Visits: 220

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 Wink

Post #1329368

« Prev Topic | Next Topic »

Permissions