Hi,
I have searched high and low, and can not find any mention of SQL2005 and mount/start database DDL triggers.
I need a trigger/job/event to update a column in a table to indicate that the database has been restarted. I can not have an application connect to the database and set this value as I am afraid one of my other computers may connect first and get the wrong state from the database.
Is there any way to have SQL2005 update a table on MOUNT/Service Start/DB start?
Regards,
Derek
I solved it on my own. I use a StoredProcedure in the MASTER database and set it to start automatically.
~Derek
No comments:
Post a Comment