Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Fsoumia
  • Content: Threads
  • Order by date
  1. Fsoumia

    DTS Logging

    I am trying to find a way to set a trigger on sys tables to log a record in my audit table every time a DTS package executes whether manually or through a job scheduler. I have been looking at these sys tables, but could not find which fields actually record the DTS package execution info...
  2. Fsoumia

    Trigger Fires for each insert update and delete action

    I am doing some auditing to find out which tables are actually being used/referenced in SQL Server 2000 Database. I have an audit table with the following fields: ID PK OBjectName. The name of the table OBjectType. The Object Type. Table AuditDate. GetDate() Initiator. SYS_USER The Trigger I...

Part and Inventory Search

Back
Top