Gail,

I see that you said that the default 0 for worker threads should be good. What is the impact of having a process spin up several thousand worker threads?...

Did the experiment work? or did the problem continue?

I thought that BIDS was basically opening VS with the SSRS Templates as a default project/solution type? We have a user now that has Visual Studio but does not...

You may have misread the question. A synonym defined locally and used locally can reference a table on a remote/linked server. It works fine. I found my...

Yes. One way is to use "cast"

for example:

select *

from table1

where cast(InvoiceID as VARCHAR) COLLATE Latin1_General_CI_AI = (select InvID from table2)

That statement makes it possible to set...

Irish,

I also received my answer to the problem from a forum user before MS found the answer. I was posting for help everywhere I could think of. I've wanted to...

A stored procedure is one place the change can be made. In the trace could you see which stored procedure or function ran the SQL statement that failed? ...

We struggled with receiving this error for 2-3 weeks after an upgrade to SQL Server 2005, and Windows 2003.

We opened cases with MS and end result was the TCP Chimney...

The people reading this chain seem to have knowledge of using local synonyms that are defined on tables on a linked server ... So am hoping someone can help out...

The client ODBC connections do have connection pooling turned on by default but I think that would just apply to their own connection. So if the server drops the...