I found the solution:

Thaks for reply. The Linked server configuration are the same on both servers. Now, i cant install SP 4 because the server is running about 20 databases, and i have...

Thanks, but we dont have enough budget to adquire this kind of tools. So, we used DMO to make backups with scripting and then programming the job in SQL (Thanks...

Many thanks for help. I used gzip and works great!

Regards.

Thanks for help, but the Operating system administrators dont want to install the Winzip (Licence Problems...). I tried using the zip.exe file included in Oracle 9i Client, but it only...

Good topic, but i have a question, is important to commit every xxx of rows inserted? is this Ok? i have a SP that makes a lot of temporary tables...

Thanks for reply. Now, any advice for after moving the databases? I mean, re-run statistics, re-rebuild indexes, ect?

Thanks again...

This works great... Thanks for help

Thanks for your Reply. This is a audit issue. They say that a user need to have a default database different that master (preferably the users databases)

It works!!! Thanks, very thanks for help!!

I have a cursor inside the SP.

I have a cursor inside the SP.

I have a cursor inside the SP.

Thanks for the advice, i was trying the EMS SQL Datapump and works fine...

Thanks for the advice, i want to tell everybody that the article i have published (how to move the whole SQL to another HW), works fine on a SQL 2000...