Stored Procs and triggers

Last Post 19 Mar 2012 10:20 AM by russellb. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
cowski
New Member
New Member

--
19 Mar 2012 06: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 10:20 AM
Sure. Have a look at DDL Triggers http://msdn.microsoft.com/en-us/lib...86406.aspx
You are not authorized to post a reply.

Acceptable Use Policy