Please don't cross post. It wastes people's time.

Please direct replies to the following thread:

Please help (SQL2K5)

Could be indexes, could be the queries, could be blocking. Without more information it's very hard to say.

Can you post the query that times out and the schema and indexes...

Are those distincts necessary?

I believe that when distinct is specified, the order by (in your case, the case statement) must appear in the select clause.

You can look in the dmv sys.dm_tran_locks

Modifying the system tables is not recommended...

Do you have any linked servers in use? Using CLR?

Please don't post the same question multiple times.

http://www.sqlservercentral.com/Forums/Topic449095-149-1.aspx

If you check the parameters for bcp in books online, you'll note that it takes a single table. If you want to export multiple tables, run bcp multiple times.

Books Online

bcp...

Yes. You have to restore the log backups, in...

Oh man! That's terrible news. I met him at Pass last year. Such a nice guy and so humble. Spoke about his work on management studio, and his plans for...

The transaction has to roll back. SQL Server guarantees that transactions are completed entirely, or not at all.

Even if you kill the SQL process and restart it, the rollback...

Having is used to filter on aggregated values. For a simple filter on a column value, rather use where.

SELECT COUNT (*), State FROM T1 WHERE Sex = 'M' GROUP BY...

Please don't post in all caps. It's the online equivalent of shouting.

Am I correct in saying you want to insert the resultset from a stored proc into a table? You...

Finally got round to trying on sql 2005. (SP 2 developer edition)

The LEN - index scan. Rated by the execution plan as 98% of the overall cost of the two...

Could we see the entire connection string please?

Just before you do the pRs->Open, print the connections string to the debug (or similar) and post the result (remving the password...