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! > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:240488 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
