Welcome to Sign in | Help
in Search

audit - sql server 2005

Last post 07-20-2009, 9:35 AM by Diana. 2 replies.
Sort Posts: Previous Next
  •  07-16-2009, 4:52 PM 7401

    audit - sql server 2005

    salut, care este cea mai simpla solutie sa pot urmari la nivel de baza de date ce anume se modifica, cine si in plus sa am si un istoric al modificariilor....ma refer la tabele, proceduri stocate etc

    multumesc

    alex.

  •  07-17-2009, 11:59 AM 7402 in reply to 7401

    Re: audit - sql server 2005

    In SQL 2005 cam trebuie sa-ti construiesti procedurile de audit "din bucati" - folosesti SQL profiler, triggeri DDL / DML / logon, log-uri de aplicatie...
    Exista "C2 audit mode", dar nu cred ca ai nevoie de asa ceva...
    Daca vrei un mediu de audit unitar si mai eficient, treci pe SQL 2008...
  •  07-20-2009, 9:35 AM 7407 in reply to 7401

    Re: audit - sql server 2005

    Uite si o sursa de inspiratie:
    http://www.sqlservercentral.com/articles/Audit/67431/
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems