I need to transfer a copy of one database into the other.
the database hasnt got that much in it at the moment but to re-enter all the data would be too big a pain.
I only have sql server 2005 express so cannot export the data into a file(or can i?)
so i can create a load of insert statements easily enough using sql....
but i need to maintain all my primary keys etc but im getting:
Cannot insert explicit value for identity column in table 'FIXTURES' when IDENTITY_INSERT is set to OFF.
when i try....
rather than have to change this setting on each table is their a gloabl setting i can change temporairly on my database using sql and then switch it back in once i have run all my inerst statements?
thanks in advance