Incidentally, just as an additional comment to my plea ... I cant use the copy database wizard, because it's a shared server and I don't have admin rights. So I cant create a database on the remote server using SQLServer management studio.
For the same reason I cant create a backup and then restore it on the other server.. For the same reason I cant use replication in any way. For the same reason, detaching, FTP then attach to the other server is out as well. I think Microsoft forgot entirely about the thousands of people using shared hosting servers when they developed SQLServer2005. And I'm told there's no provision for it in the new 2008 version either. <sigh> Cheers Mike Kear Windsor, NSW, Australia 0422 985 585 Adobe Certified Advanced ColdFusion Developer AFP Webworks Pty Ltd http://afpwebworks.com Full Scale ColdFusion hosting from A$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3167 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
