Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Van
Constraint Violating Yak Guru
462 Posts |
 Posted - 2009-06-08 : 15:55:18
|
| I've searched around this forum and couldn't find an answer. I'm hoping someone can help me out. I know a little about DDL triggers and I've created one for server type events (create database, create login, ect) and it works fine. What I'd like to do is to create one to let me know when someone does a database event (say creates a table or alters a table). The catch is that I want it to work on all databases. I think I could create one in each database with the "ON DATABASE" part but I was wondering if I could create one trigger for database events that works across all databases. If not, I guess creating one in each database (20 or so) and creating it in the model database (for new dbs that get created) would be the way to go.Thanks,Van |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-06-08 : 21:06:36
|
| Standard reports come with SCHEMA CHANGE REPORT. USe it instead of degrading your SQL Servers performance. |
 |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2009-06-09 : 12:53:26
|
| Can you tell me where to find the standard reports or do you mean to create one. We don't have reporting services installed. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-09 : 13:22:43
|
| nope...you have a set of standard reports which you can see by opening sql management studio and connection to your server and clicking reports folder |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2009-06-09 : 16:14:08
|
| Thanks for the info but I can't find the Standard Reports or a reports folder in management studio. Can you tell me where it is? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2009-06-10 : 09:45:38
|
| I take it that there is an add on that you have to install to get dashboard... |
|
|
|
|
|
|
DDL Trigger question