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

Trigger FOR DDL_DATABASE_LEVEL_EVENTS Expand / Collapse
Author
Message
Posted Wednesday, March 20, 2013 2:10 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 3:42 PM
Points: 82, Visits: 660
I have this trigger set up and I have one application that is unable to load when logging into the application as sa user.


at Login
Error was raised during trigger execution. The batch has been aborted and the user transaction if any has been rolled bac.


Does any one know what I need to put in the trigger to allow this user to login all normal users have no issues only the sa account has issues. This account is creating some table at login I believe.

we saw this create tables after clicking ok on the first pop up with the error.
'amAutoGrant', 3616 "gpAppEnabled"

Thanks in advance
Post #1433473
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse