Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    7

    Arrow Unanswered: Database Level trigger is possible in SQL 2000?

    Dear Freinds,

    we are having an requirement to log the unauthorized backend update on database.Is there any other way ,apart from going and creating the triggers at each table to log the backend update.

    Note :Is Database base level trigger is possible on SQL Server 2000?



    Looking for your reply.

    With Cheers ,
    Sathesh.M

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    No, database-level triggers are not implemented in 2000.

    And the way to handle unauthorized backend updates is with proper security.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    May 2006
    Posts
    7
    Dear Blindman,

    We are having all level of database security,there are 40 support people
    working on this pro.,we want to track there updation also.


    With Regards,
    Sathesh.m

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You'll need to put triggers on the individual tables.

    Every table I create contains columns for MODIFIED and MODIFIER, with an update trigger to set them to GETDATE() and SUSER_SNAME().
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •