AX Development

USE [rmsprod] GO /****** Object:  StoredProcedure [rms].[PROC_SERVER_ACTIVITY]    Script Date: 10/19/2010 15:39:16 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [rms].[PROC_SERVER_ACTIVITY] AS BEGIN /***************************************************************************************** Stored Procedure Name:   [dbo].[SERVER_ACTIVITY] Date Written:            AUGUST 2010 Author: CHITANYA CHITTURI                                   Project/System:                                                       Purpose/Description:     Input Parameters:     Output Parameters:                 ...

CREATE TABLE YourLogTable(ModificationTime DATETIME, [Application] NVARCHAR(500), [SQL] NVARCHAR(MAX)) GO CREATE TRIGGER [dbo].[trgUpdateLogger] ON [dbo].[YourTable] FOR INSERT,UPDATE,DELETE AS --Get updating process info CREATE TABLE #s(EventType VARCHAR(30), Parameters INT, SQL NVARCHAR(MAX)) INSERT INTO #s EXEC('DBCC INPUTBUFFER(@@SPID) WITH NO_INFOMSGS') --Write to log table INSERT INTO YourLogTable (ModificationTime, [Application], [SQL]) SELECT GETDATE(), APP_NAME(), #s.SQL FROM #s --Cleanup DROP TABLE #s GO Note: I found it on LinkedIN... thought it might be useful