They change $5 for a restore. I'm trying to avoid this, not because of the cost but because I should be able to do this anyway.
I applied service pack 2 and fixed the problem. Thanks for the help. -----Original Message----- From: Allan Grabnoski [mailto:[EMAIL PROTECTED] Sent: Thursday, August 16, 2007 2:49 AM To: CF-Community Subject: Re: problem copying database with Microsoft SQl Server 2005 Can you do a restore / backup ? On 8/16/07, Matthew Smith <[EMAIL PROTECTED]> wrote: > > I am trying to copy a database from the crystaltech server to my new local > install of MS SQL Server 2005 Enterprise (trial version). > > In SQL Server Management Studio, I go to Tasks>Copy Database which opens > the wizard. When I get to the select database screen I get this error: > > Server user 'username' is not a valid user in database '123foo' > > (123foo is the first database of all those on the server) > > I need have it look only at my database which I have permissions for to > copy it. How do I do this? > > I tried copying the tables the other way(import data) but it dropped all > my identities and primary keys which is a pain to recreate. Is there a way > to copy tables from one server to another without losing primary keys and > identity fields? > > Thanks for any help! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:240500 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
