Not completely sure what you are trying to get at but might try something like this:

select disctint @id = id from idtable

select @sp1 = sp1, @sp2 = sp2, @sp3 =...

That caused a 4 table update to only update some tables and not others and changes did not get rolled back in tables that had already been updated in the...

We used XACT ABORT ON where I worked. The biggest issue we had was if you were to call another stored proc within the stored proc using XACT...

You could also try detatching the databases, copying the MDF and LDF files to a CD, then reattaching them on the source server. Then copy the MDF...

It might take longer to create the index on the fly than the transaction is using at this time (30 minutes).

try casting your @sid to a varchar when you make set your query variable.

What are you doing with the 10 million records? Aggregating? Feeding into another application? The intended use of the records may provide...

Try setting your 2nd and 3rd parameters to allow nulls. That should let you process the report without requiring them to be filled in. ...

At the very least, rebuild the statistics on that database. Better yet, rebuild all indices on it. That should help the...

The error indicates that your connection information to the report server database in the rsreportserver.config file has become corrupt.

Please look at this article.

http://msdn.microsoft.com/en-us/library/ms156468.aspx