Can't copy/export a database with identity NEWBIE

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Jeffrey Brandt" <jdbrandt@xxxxxxxxxxx>
Date: Sat, 23 Jun 2007 11:50:41 GMT

I have a database where some tables have the IDENTITY = YES.

If I copy or export from ServerA to ServerB, the IDENTITY gets set to No.

This has to be a simple problem.

How is it fixed?

.

Follow-Ups:
- Re: Can't copy/export a database with identity *NEWBIE*
  - From: Hilary Cotter
- Re: Can't copy/export a database with identity *NEWBIE*
  - From: Paul Ibison

Prev by Date: Re: Error 14113 while trying to setup replication on SQL Server 2000 S
Next by Date: Re: Can't copy/export a database with identity *NEWBIE*
Previous by thread: Re: Error 14113 while trying to setup replication on SQL Server 2000 S
Next by thread: Re: Can't copy/export a database with identity *NEWBIE*
Index(es):
- Date
- Thread

Can't copy/export a database with identity *NEWBIE*

Can't copy/export a database with identity NEWBIE