Having battled this all day yesterday, the answer was to explicitly place the report server service in my bypass list in IE.  For example:

http:\\reportserver\reportserver\reportservice.asmx

This appeared to become a problem after...

I have continued battling this and may have found the problem, but I still do not have the solution.  I have created a VB.NET WINFORMS project and created a refernece...

It would be much easier to help if you posted the code.  I have seen a similar problem in SQL 7 where an sp runs quickly then starts to hang...

DTC needs to running on both servers and the servers need to be able to access each other.  Meaning that ServerA has to be in either the DNS host fro...

COuld you post how you are connecting (the connection string)? and what application you are using?

I don't know how or why Access returns the table name and SQL does not, but SQL returns all the fields from table1 then all the fields from table2.  A...

You are never getting to your error handling routine because the SQL Statement with the error is never being executed so the procedure terminates at that point without hitting a rollback...

After running the sp in the data tab you click the "Refresh Fields" button on the data tab.  Third button on the right of the Dataset.

I would have to see the url. 

You do not need to have SQL installed on the web server in order to have it serve as the reporting services web server.  You can install the reporting services...

What do you mean by we do not have XML access from RS?  Do you want to query XML data or return XML data?

If you want to return XML just...

Here is a snippet of code from an aspx code behind page in VB.Net that does what you want. 

Private

Sub btnSubmit_Click(ByVal

This is one area where RS is like an Access Report.  If you have one thing over hte page margins then you get essentially a blank page.  I would make...

I like msSQLed available free or for $15 to get rid of an annoying pop-up at http://www.mssqled.com/DesktopDefault.aspx.  YOu can also get a free web-based data admin tool from Microsoft...

I did notice that using table variables was slower than using temp tables when there was  relatively large amount of data being insertd into the table variable.  I found that...