Have you tried creating the table with a select * into, duplicating the indexes, droping the old table and renaming the new table back to tb1?

I had a similar issue...

When you created the ODBC connection, did you test the connection?  And if so, was it successfull?

I installed the AS/400 DB2 ODBC driver in a previous job.

As John mentioned, Linked Server or DTS work just as well as each other.  We used a lot of DTS becuase...

I agree with dclark.

It makes for easier management long term.

Also, with the databases seperate, if somewhere down the line you did need to query data from another database, then you...

Have to agree with Colin.  Trying to optimise performance by boosting hardware or having ways to control hardware is always going to show up flaws down the line.

If I was...

And another one ... not me this time tho!   And just what I needed on the night of our month end run while...

As Rudy mentioned, a good place to start is if a process was running for 10 minutes before it was killed, a basic assumption is that it will take 10...

are you sure that wasn't directed at me Colin....

1 & 2) Yes!  There are scripts on this site which I have used to identify and delete duplicates!  Unfortunately I just tried doing a search but I am getting...

Interesting!

Is this on the server or when using EM from a client PC?  Either way, what login are you using in the registration...

I did write a query to return this.  Will have to dig it out and post.

Not sure if there is a minimum size of a log backup.  The smallest I see in general is 33Kb on my server.

With regards to checking the tlog, i guess,...

Assuming you have a test environment?  If so, have you restored the database there and can you reproduce the error?

If not, can you run the query/proc from query analyser?  What...

Im assuming the query works in Query Analyser and if so, how long does it take to return the result set?

Yup

Ran a DBCC SHOWCONTIG () WITH TABLERESULTS, ALL_INDEXES on a 180m row table.  It has about 9 indexes.  Ran for about 30 minutes.

I...