Log changes to text file fromtrigger

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jo Pattyn SSC-Dedicated Points: 32352 More actions · Answer 1

There is no standard command for logging DataModelingLanguage-statements.

If you mean datachanges, you could periodically start a job that would write data from the auditing table to a file.

Umesh Shinde SSC Veteran Points: 297 More actions · Answer 2

Hi Jo

Thanks for you reply

Then can u give me the syntax how to make a

string of all the fields data by concate and place it in a single string or varchar field of auditing table. This will also very useful for me

Regards

Sumesh

Jo Pattyn SSC-Dedicated Points: 32352 More actions · Answer 3

Mostly we create a Trigger on a table:

Table Original

Column1 (PK)

Column2

Table History

Column1

Column2

ChangedDate

ChangedUser

CREATE TRIGGER TR_ORIGINAL_INSERT ON dbo.Original

FOR INSERT /*INSERTS ONLY*/

INSERT INTO dbo.HISTORY

(column1,column2,ChangedDate,ChangedUser)

SELECT Column1,Column2,CURRENT_TIMESTAMP,CURRENT_USER

from inserted.column1,inserted.column2

Your application can read out the columns and concatenate them

Umesh Shinde SSC Veteran Points: 297 More actions · Answer 4

Hi Jo

Thanks once again

My actual problem is i have puchased readymade

ERP s/w and there are around 1500 tables in the

database and i wants to track the table changes

step by step after executing steps in a process like create, process, book, close purchase order . can u suggest me solution for this that

how i can track changes in database after each step.

Thanks& Regards

Sumesh