Posted by Steve on 05/16/07 16:34

Hi;

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?

Thanks in advance for any information

Steve





-------------------------------------------------------------------
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

• Next in forum: Re: Rants. Difficulty to learn ETL tools?
• Prev in forum: Re: how to if needed recover from mistake
• Thread view: SqlServer 2005: Importing Data: Idenitity fields getting made into non-identities

[Reply to this message]