Thanks Steve for your help. I appreciate it.

I understand ur approach. But the problem there is the user can be a Vendor A user or vendor B user or a...

Thanks Steve,

I like your idea but i might have situations where one user could be a part of customer and vendor. Its NOT one to...

Hi noel,

I appreciate your suggestion.What do you mean by publication management issues?

Thanks,

Kayal

Thanks everybody for your suggestion, that helps. I am gonna go with the identity column and have not for replication set to yes.

Thank You guys. I really appreciate your help....

Hi Frank,

Thanks for your reply. Appreciate it. After you import template in MDDE, how do you work on it to generate dynamic SSIS ? Please advice. What is the...

I found this trigger definietion in the internet, which helps..

A trigger is included as part of a single transaction with the statement that invokes it. Therefore, a rollback statement can...

Lynn,

I have a table say tblCustomer. I write trigger(AFTER UPDATE) on this table which inserts a record in another table,tblAudit . So you mean to say, the...

Hi all,

I have another clarification. How will i know the trigger is executed successfuly or not(means whether it updates the audit table). If it does not,will it rollback the...

Hi GSquared,

Thats awesome.. I did not know about SELECT .. FOR XML until now. Thanks a lot :). I appreciate all your suggestions. Thats a good one.

Thanks,

Kayal

Got it. Thanks tore 🙂

Thanks Tore. Thant really helps. Appreciate it.

-Kayal

Jeff,

Even i dint get what u mean by "copy of table schema". How do you achieve that. And how do you store the previous and current value in XML....

Hi all,

There is a small change in the requirement. And so, we assume to hav only 200 transactions per day.

Thanks,

Kayal

Hi Tore,

Thanks a lot for your help and your time. This is good piece of information. So u mean to say having audit table for each table is...

Thanks, steve.. That helps