We are using SQL 2000 and there is no option to capture XML excution plan.

THanks

Shuaib

Log file is must for the DB in Sql. If you want to get rid of the big log file, at the end data migration process, add the following steps:

1....

Log file is must for the DB in Sql. If you want to get rid of the big log file, at the end data migration process, add the following...

The job will run only if both Job & its schedules are enabled. Check your job's scheduled.

The local temporay table doesn't have the cluster index. I will create and hope it will not have any issues. Thanks for your help and info.

Thanks. It helped me to arrive the expected results.

Can you please clarify the order of the data in temp table? I am inserting the data into...

NODE1 is my DNS server.

after dropping any index, sometimes the sys table will not update the correct info. use either DBCC UPDATEUSAGE or sp_spaceused , @updateusage = 'true' command.

I am trying to setup a test environment. I dont see any check box saying "register must succeed".

Thanks

Shuaib

I tried several times to install sql 2005, the setup is unable to register the Virtual server name. I am keep on getting the message

"The Virtual Server name...

How to check if the virtual server name exists in the network and how to add to network if it doesnt exists?

Thanks

Shuaib

I just found that the error came from an Update trigger. I didn't realize while executing the script. I have disabled the trigger and executed the scripts without...

It worked for me. Thanks Again

Thanks lot for you info.

I also found the Numbers table details.

Can you please add the Numbers table too