Thanks for your help guys..

This did not help me. The timeout error still persists.

Is ther any other way to enhance the performance of the execution of the Triggers.

- thanks

Sharan

-Sharan

Andy, Can you explain it in detail on what you wanted to say.

Thanks

-Sharan

A quick Question, wat are the different ways to increase the Connection and Command Timeout Properties of the sql connection string?

-Sharan

Thanks..

The Trigger Updates Table2 based on the modification done to the 8 columns in Table1 for which the Trigger is defined.

If Update(Table1.Column1)

Update Table2

Set Table2.Column1 = @data

Where (Based on...

Thanks..

The Trigger Updates Table2 based on the modification done to the 8 columns in Table1 for which the Trigger is defined.

If Update(Table1.Column1)

Update Table2

Set Table2.Column1 = @data

Where (Based on...