Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    india
    Posts
    67

    Unanswered: Identify value in a column nullified

    hi,

    I have a huge db with many services ,users and applications hitting the db.
    Suddenly one of our column is nullified , we are not able track who /how it is done,

    Can any one tell be whatz the best way to identify this????
    trace(what events to select ), trigger or what????



    Thanks,
    srini

  2. #2
    Join Date
    Jul 2002
    Posts
    229
    Do you mean the value is changed to Null or that the column's Null Allowed property has changed?

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    How frequently does it happen?
    If it is fairly common, you could use SQL Profiler.
    If it happens rarely, you can put a trigger on the table to create a log record when a null value is inserted, recording the datetime and logon of the connection that performed the operation. Use some of the NILADIC functions to determine login information, such as 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
  •