Thanks guys. My databases will be always on different servers. Will the above solution work? What modification I can do?

Thanks

Sundar

Hi Naveed,

I am working on a similar issue. There are 2 SQL Server databases. I need to transfer all the data from tables in source DB to target DB...

Have you resolved the issue? I am running to the same problem. I could not install SS2005 on Windows Vista 64 bit OS.

Any help will be greatly appreciated.

Thanks

Sundar