timeout expired problem

[Harrison]

I am dealing with a large row set in sql server, and I receive a timeout expired error while processing an INSERT INTO statement . Anyone know how I can fix this?

 

[Logan]

I am dealing with a large row set in sql server, and I receive a timeout expired error while processing an INSERT INTO statement . Anyone know how I can fix this?

Is it an ASP script timeout? If so, you can increase the timeout threshold to something that exceeds the typical time required to complete the insert.

Another option is to break the insert into one INSERT and one or more UPDATE statements. I do something similar when I insert an image into a database. I insert the record without the image data so that I can get a record ID number quickly. Then I insert the image data as an UPDATE statement.

 

[Harrison]

yea i see the threshhold your talking about that did the trick. thanks.