InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 10:40:56 GMT20http://www.sqlservercentral.com/Forums/Topic1391613-391-1.aspxMuch better than my approach. I keep forgetting to check Extended Events for solutions to problems like these. Thanks for posting Lowell.Mon, 03 Dec 2012 07:04:39 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1391613-391-1.aspxI'm sure you have to use extended events, specifically on the [b]AUDIT_BACKUP_RESTORE_EVENT[/b]I did something as a prototype that did a few things on my dev server;if you restored a database, then it added roles if they did not exist, and another one that looked for and fixed orphaned users.so when a database gets restored a stored procedure gets executed with my desired code, with references to the database in question.this article By Jonathan Kehayias, 2009/12/22 was my starting point that i added code to.[b][url]http://www.sqlservercentral.com/articles/Event+Notifications/68831/[/url][/b]Mon, 03 Dec 2012 06:55:27 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1391613-391-1.aspxCan you just build the query into the process that does the restore?If not, you'll need to have a T-SQL statement with a TRY/CATCH that you can run, probably on a schedule from SQL Agent. Then, if it can USE the database, it runs the query, if not, it errors out until next time. Not sophisticated, but it will probably work.Mon, 03 Dec 2012 05:43:22 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1391613-391-1.aspxHi,I'm looking for how I can have a query run against a database when it is restored. Basically, I have multiple copies of the same db structure with some default data that when restored, I would like to run some queries to adjust configuration. There must be a way to setup a trigger to run a Stored Procedure or a set query but I am having trouble finding documentation.Can anyone point me in the right direction?Thanks in advance!Fri, 30 Nov 2012 18:33:33 GMTlisa_stlaurent