Thanks for the link, I've been able to skim it and while it may not solve my immediate issue there is a lot of great info there.

D'oh, didn't think about checking dmv for longest running queries. Except now its too late as the server has been restarted. (Restarts every day at 1am. 3rd party...

No changes had been made to the server over the weekend and we preform most of our maintenance between 11pm - 1am so I don't think it was related to...

Thanks for the links on the autogrow.

The log_reuse_wait_desc and DBCC OPENTRAN() didn't return anything interesting - are these more likely to be useful right when / after the issue...

Thanks, that worked great!

Thanks for the reply but that didn't seem to work. I wound up with a single row with alternating blank columns and the date

,'', '2008-2-24','','2008-2-17',''

etc.

Thats perfect! I like how you only target the varchar etc fields and ignore the binary ones - they gave me some grief with the previous code. While...

May not have been clear, but I'm actually using this to scan through the actual data. The code I posted was originally used to count the number of times...

Not an expert on this, but here goes -

Open QA and set it to the destination DB.

Run a series of queries

Select *

Into Table_A

from sourceDB.dbo.Table_A

Select *

Into Table_B

from sourceDB.dbo.Table_B

.....

Select *

Into Table_Z

from...

That did it.  Thanks for the tip!

Thanks for the replys guys.  And I had a typo in the first email - its actually a 2005 system if that changes anything.

This was going to be used for...

Got it figured out. This should all be on 1 line under the navigation area.

="javascript:void(

window.open('http://mysite.vendorRating.php?vendor=" & fieldName & "','open_window', ' resizable, dependent, width=600, height=300' )

)"

Thanks for the help.

Robert, that description makes perfect sense.

We got done with the necessary updates and this was a one time thing, but I will remember the nolock tip!

Bib

I got back SP4, 8.00.2039

and further testing of the system seemed to indicate when we had the application for this database open and were viewing records from the table, it...

.... ok, so something's changed on the server. After not working for over an hour, the table is suddely responsive once again at over 58k records. I was...