Best way to implement an audit trail in SQL Server?

by

There are many ways to do that; it depends which version of SQL Server you are using.

Here are few

More Related Contents:

  1. Local and global temporary tables in SQL Server
  2. Get first day of week in SQL Server
  3. What is the significance of 1/1/1753 in SQL Server?
  4. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  5. How to delete large data of table in SQL without log?
  6. Insert Update trigger how to determine if insert or update
  7. SQL Server: UPDATE a table by using ORDER BY
  8. EF5: Cannot attach the file ‘{0}’ as database ‘{1}’
  9. Do I really need to use “SET XACT_ABORT ON”?
  10. What is a Trusted Connection?
  11. Understanding SQL Server LOCKS on SELECT queries
  12. Do while loop in SQL Server 2008
  13. Connecting to MS SQL Server with Windows Authentication using Python?
  14. Using COALESCE function to make values separated with commas
  15. How to find the port for MS SQL Server 2008?
  16. Assign result of dynamic sql to variable
  17. How do I create a multiple-table check constraint?
  18. Stored Procedure and Permissions – Is EXECUTE enough?
  19. Stored procedure – return identity as output parameter or scalar
  20. SQL Server Group by Count of DateTime Per Hour?
  21. How to import a DBF file in SQL Server
  22. SQL Server Dependencies
  23. SQL Server: Filter output of sp_who2
  24. How can I insert binary file data into a binary SQL field using a simple insert statement?
  25. Why do I get the error “Xml data type is not supported in distributed queries” when querying a linked server for non-xml data?
  26. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  27. Date range overlapping check constraint
  28. Conditional JOIN Statement SQL Server
  29. How do you deal with blank spaces in column names in SQL Server?
  30. ODBC Call Failed with stored procedure – Pass through query

Leave a Comment