I want to Create an alert for Sandbox(Database) and DataRepository(Database) where Any object (Tables, Views and SP) should not be referenced. Can anyone help me with this ?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
I might be over simplifying this.
If those objects shouldn't be used why don't you revoke permissions to anyone that shouldn't be using them. Surely, creating an alert allows them to use those objects/get at data until you have time to resolve it - imagine being on holiday on for two weeks and your team members don't pick up the alert!
Answers Answers and Comments
21 People are following this question.
Converting Decimal to Time
Obtaining the Number of working days in a month
How to display Database when using sp_foreachdb
SQL database stuck in Recovery Pending
what is the best way to rewite a oracle sql query to sql server 2012