Is it possible to run a stored procedure automatically on a new database when it is attached? Replication is causing issues on our daily snapshots.
What we would like to do is remove replication automatically on a database when it is attached to the SQL server.
Is this possible?
This Link may answer your question. An hourly job as pointed out by David Browne would be my choice.