When your Database contains a
How would you fix the database to come up again.
I have seen that -gf is implemented to disable triggers. Is there somthing like -xyz to disable events from the command line ?
Think of the posibilities. Implement a bogus DatabaseStart event and when you bring up your server 3 Month later it is blocked. And you did not try to start you backup database ;-)
asked 25 Feb '10, 12:06
You should have a safety belt in place when you are working with the DatabaseStart Event.
Enclose the risky part of your event in a if clause that checks the Name of your server instance.
So when your database is not starting up correctly you can start the server with a special Name to avoid execution of the event
Then you are able to drop or fix the DatabaseStart Event
answered 18 Mar '10, 10:51
Contact tech support -- suppressing events can be done. -john.
answered 16 Mar '10, 13:54