Look also at products like Double Take

The UPDATE statement has an implicit transaction (when the connection Implicit Transaction is ON), but when you update multiple number of rows in a table, with or without explicitly starting...

Try giving to the account that runs the SQLH2 service, full rights to the SQL Server registry using regedt32.

Thanks guys, I thought there is an easy way to do the update, something like an update hint, that would direct the update statement to lock only one row at...

Hi John,

I am experiencing the same issue, did you got your issue solved, if yes, how?

both

not sure how you try it but I done a SSIS package with a Transfer Logins Task and is doing it without errors.

You are right, I used the migration utility.

I exported the 2k DTS package as a dts file, imported into Legacy, and now I can open it, no error.

Thanks

I installed the Microsoft SQL Server 2000 DTS Designer Components  , I can edit the packages via Visual Studio (Execute TDS 2000 Packages), I can see the packages on Object...

I have done some testing with migrating MSSQL 2k DTS packages to a MSSQL 2005 name instance, and supprisingly, you can not see that 2000 packages under MSDB unless you...

can you change the owner of the database to sa?

Even if you try to bcp or use DTS to take data out of tables, one by one?

From a different point, can you afford to run

checkdb with REPAIR_ALLOW_DATA_LOSS?

Where did you got stucked?

Simplistically and I am not 100% sure that will work exactly as follow since I haven't test it, but hopefully it would give you some ideas.

Create a database with the...

Can you run DBCC CHECKTABLE on CallList table, it seems to me that is the one with issues.

If not, you can run DBCC CHECKTABLE in a loop on all the...