How to write a trigger firing when someone made specific changes and saved on SQL Server

Question

I am new to SQL triggers scripting. Right now, I want to write a trigger firing when someone modify a create or alter statement in table definition in SQL Server and saved.

Can someone please tell me what can make this happen and what kind of trigger should I research on?

So far I have only read some dml triggers tutorial and it's not quite alike to what I want.

Because I want launch a .net program through cmd when the trigger is fired. Is there any alternative to do that? — Joshua H., May 28 '12 at 21:16
In that case Service Broker and Event notifications are possibly more suitable. — Martin Smith, May 28 '12 at 21:18
Yes clr stored procedure well given you are on 2005 or later. Is this server under your control? xp_cmdShell is blocked by default. — Tony Hopkinson, May 28 '12 at 21:20
Just found this answer which looks like it might be relevant? http://stackoverflow.com/a/1562066/73226 — Martin Smith, May 28 '12 at 21:22

score 0 · Accepted Answer · answered May 29 '12 at 21:22

0

DDL is my option to do it. http://msdn.microsoft.com/en-us/library/ms186406(v=sql.105).aspx

answered May 29 '12 at 21:22

Joshua H.

537
3
9
19

How to write a trigger firing when someone made specific changes and saved on SQL Server

1 Answers1