Posted by Erland Sommarskog on 05/16/07 22:42

Steve (tinker123@gmail.com) writes:
> We just migrated to SqlServer 2005. When I import tables from from
> SqlServer database into another the identity fields get switched off
> from being identities.
>
> How can I prevent that from happening?

Seems like the way to go is to click Edit SQL and add the IDENTITY
property manually.

> Microsoft SQL Server Management Studio
> 9.00.1399.00

This is the RTM version. I recommend that you install SP2, which
has several enhancements to the tools. If you plan to use maintenance
plans, make sure to get hold a GDR that fixes two serious bugs in
SP2 with maintenance plans.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: how to if needed recover from mistake
• Prev in forum: Re: SQL server 2000 - database problem
• Thread view: Re: SqlServer 2005: Importing Data: Idenitity fields getting made into non-identities

[Reply to this message]