Home Forums SQL Server 2005 SQL Server 2005 Security Trigger to add user to db_owner role after db restore RE: Trigger to add user to db_owner role after db restore

  • November 27, 2009 at 9:55 am

    #1084973

    You ca use Service Broker Technology to capture the Event and raise an action

    Review this article and modify it according your requirement.

    http://www.sqlteam.com/article/centralized-asynchronous-auditing-with-service-broker.

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector