1)use db_name

2) set the database recovery to simple - sp_dboption 'db_name', 'trunc. log on chkpt.', true

3) write a store produre to delete about 10000 per loop. After each loop...

try renamming the server

1) sp_dropserver 'OldServerName'

2) sp_addserver 'NewServerName', local

3) then Retstart mssql

to verify -- select * from master..sysservers

the NewServerName ...

drop all indexes then BCP in data (fast bcp). After BCP is done recreate the indexes.

i usuually uninstall and reinstall with correct collation. I believe you can't use your present databases in the new collation you are trying to re-create the instance with.

this may help

How to run profiler in batch mode:

start profiler and create new trace -- click - save to file, roll over & max. file size 100 meg then select...

see if this helps

declare @dumpdest char(100)

declare @date varchar(20)

select @date = convert(varchar,getdate(),112) + convert(varchar,getdate(),108)

select @date = stuff(@date,charindex(':',@date),1,'_')

select @date = stuff(@date,charindex(':',@date),1,'_')

set @dumpdest = 'c:\junk\db1_' + @date + '.tdmp'

backup log db1 to...

Aaaaah! this is music to my ears!

HEY! show me the money!

BCP out the two tables to saprate files use NT/Unix diff utility

H. Singh