More than anything else, this was an attempt to keep processes required by different teams apart from each other's. The "restoring" process belongs to our DBA's. It is a process...

Thanks. Your wise counsel has be recorded and minded.

That's under consideration, but we wanted to try it with a trigger if it was possible. Is it impossible because sys.databases is a view?

Very close. I want to monitor this view so that when the database is finished restoring, and the value in the sys.databases 'State' column returns to 1, I can execute...