Home Forums SQL Server 2005 T-SQL (SS2K5) Value of bit field changed on table - trigger to track when/how it changed? RE: Value of bit field changed on table - trigger to track when/how it changed?

  • July 7, 2009 at 12:53 pm

    #1021282

    Sounds like an audit table is needed to capture this info for future analysis. What you are looking for you can find in Books Online, the SQL Servr Help System. part of what you need you should be able to find in system functions, like USER_NAME(). There are others as well, so read about them.