Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Securty Trigger stroed procedure Expand / Collapse
Author
Message
Posted Wednesday, August 7, 2013 4:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 2, 2014 2:39 PM
Points: 64, Visits: 513
Hi Lowell,

Using DDL Trigger script , I deployed in Sql 2008 server and found few DDL events not capturing.

Example:- TestA SQL server login I created and grant SA permissions , using that login I created TestB login.

This type of activites DDL triggers not loading into table. Can you please guide me , do I need to use any server objects like service broker or any messaging techniques to track all DDL activites.

Thanks ,Kumar.
Post #1481776
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse