June 23, 2015 at 6:57 am
I have a situation where a person, who created our DW, likes to go in and change table name. This person had no prior SQL xp and is at a higher level then me in the company. I need to know whenever somebody changes a table name I get notified, with the old table name and the new table name. This can be either set on the server level or the DB level. I would like to use the policy management but cant find the way to do it.
Thanks
June 23, 2015 at 7:33 am
I'd suggest investigating Event Notifications or using a DDL trigger. Event Notifications will probably have less impact on your server.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 23, 2015 at 8:13 am
I've been running Red Gate's DLM Dashboard for a while now on one of my dev servers, and it does a good job of tracking any DLM changes. Right now it's free, so it might be worth checking out.
June 23, 2015 at 8:18 am
cphite (6/23/2015)
I've been running Red Gate's DLM Dashboard for a while now on one of my dev servers, and it does a good job of tracking any DLM changes. Right now it's free, so it might be worth checking out.
DLM Dashboard does use a DDL trigger, and is certainly an option.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 23, 2015 at 8:31 am
This is exactly what DLM Dashboard was designed to do. Catch changes in schema. It works well for me in small projects here.
Disclosure: I work for Redgate.
June 23, 2015 at 8:34 am
Steve Jones - SSC Editor (6/23/2015)
This is exactly what DLM Dashboard was designed to do. Catch changes in schema. It works well for me in small projects here.Disclosure: I work for Redgate.
Disclosure: I wish I worked for Redgate.:-D
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 23, 2015 at 8:37 am
Thanks for both of your help, I am going to look into the Event Notification
June 23, 2015 at 8:38 am
Steve Jones - SSC Editor (6/23/2015)
This is exactly what DLM Dashboard was designed to do. Catch changes in schema. It works well for me in small projects here.Disclosure: I work for Redgate.
I think there are several of us that wished that.
June 23, 2015 at 8:41 am
Lynn Pettis (6/23/2015)
Steve Jones - SSC Editor (6/23/2015)
This is exactly what DLM Dashboard was designed to do. Catch changes in schema. It works well for me in small projects here.Disclosure: I work for Redgate.
I think there are several of us that wished that.
Several, yes.
Disclosure: Wish I won the PowerBall lottery and didn't have to work. 😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 23, 2015 at 9:16 am
Steve Jones - SSC Editor (6/23/2015)
This is exactly what DLM Dashboard was designed to do. Catch changes in schema. It works well for me in small projects here.Disclosure: I work for Redgate.
Redgate also runs this forum... it's a conspiracy!
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply