Thanks.

The syscomments table shows portions of text from the procs, but not complete versions. Doesn't seem to matter if I view it in grid or text mode.

Is there something else...

Thank you for your reply.

We made several modifications, including:

1) making sure datatypes on the join fields were consistent between tables

2) breaking it up into smaller chunks

3) viewing execution plans and...

Thanks...

I tried

SELECT * FROM TableC WITH (NOLOCK)

but that appeared to hang and in one instance rendered both the original process and the select...with (nocount) into sleeping mode in Enterprise...

Hi Jane,

I had a similar issue about a year ago, but I'm not entirely sure how it was resolved.

I think part of the problem was that I was running the...

I'm new to this as well.

Do all the off-site instances of the application interact with the same central DB?

If they do, do you need to update the central DB live?

If...

I've had past issues with CONSTRAINTS, where you may need to drop the constraint first before altering the table.

Peter

Thanks Greg.

Unfortunately, that is part of the problem. I am trying to find a means to standardize several elements. File naming conventions and layouts are...flexible. One thing going for me...

Thanks Razvan, the connection timeout settings were among the first things I checked, and they were set to 0 in all the proper places.

Thanks Alamir, I'll try the "with no...