Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Use Powershell to delete a logon trigger that has locked down a DB? Expand / Collapse
Author
Message
Posted Thursday, July 12, 2012 3:11 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:44 AM
Points: 50, Visits: 306
Hi,

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

Thanks, Phil
Post #1328741
Posted Thursday, July 12, 2012 3:30 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:28 PM
Points: 33,189, Visits: 15,328
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
Posted Friday, July 13, 2012 5:16 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:44 AM
Points: 50, Visits: 306
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 .
Post #1329368
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse