Could you post the entire sp that is giving you the error?  It is hard to tell what the problem could be from the snippets you have provided.

Both boxes are int the same domain.  The SQL Server is running under a Domain account and allows both SQL and Windows logins.  I have tried setting up the RS...

My first question would be why the temp tables are not being dropped when the connection is closed?  The statement you list will work with the following changes:

if exists (select...

Could you post your select statement?  I use linked servers using ODBC to an AS400 and have not seen this particular issue.

Does the first dataset create a table in SQL or a table in the report?  If it creates a table in the report I don't think there is a way...

We had this problem just logging into one of SQL Servers using NT Authentication.  I believe we had to reboot the SQL Server in order to use NT Authentication.  It was...

I probably should have included the if exists in my sample.  I would replace the COunt(*) code and the if @type = 'Update' to this:

If Exists(Select * from deleted) --updated...

Using Distinc and then doing concatenation is definitely going to slow down the query.  Distinct can cause a table scan.  You would be better off to use a group by...

I always favor stored procedures for data access.  Even if I were using views I would not write select statements in the front end against the view, I would write...

First off, looking at your code, you have an insert update trigger so if it fires there will ALWAYS be data in the inserted table, so getting a row count...

This is in addition to my last post.  I participated in a Web seminar on RS by SQL Server Magazine last week and they demonstarted creating a standard report template...

Rayven,  are you going through any kind of Proxy server that may be caching the PDF?

I had the other problem with blank pages sort of.  I had 3 subreports on a report, ...

Try this, it's not all that much differnet from what you already have:

Create FUNCTION

dbo.udf_GetEMpsBYManager

(

@empid

char(6)

)

RETURNS

@table_variable TABLE

Much simpler to begin your sp with Set Transaction Isolation Level Read Uncommitted.  This means that any selects in the batch/sp will allow dirty reads, but will not hold locks,...

I'd go with A as well.  I'm guessing you could very cheaply add Hard disk space to A if you find the need.  You also want the development server ot...