Stored Procs and triggers

Last Post 19 Mar 2012 11:20 AM by russellb. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
cowski
New Member
New Member

--
19 Mar 2012 07:39 AM
Is there a way to set up a trigger so that if a stored proc is altered in anyway, a log could be kept of what stored proc was changed, when & by who? If so, how would I go about in setting something like this up? Thanks!
russellb
New Member
New Member

--
19 Mar 2012 11:20 AM
Sure. Have a look at DDL Triggers http://msdn.microsoft.com/en-us/lib...86406.aspx


Acceptable Use Policy
---