You are here: Re: SqlServer 2005: Importing Data: Idenitity fields getting made into non-identities « MsSQL Server « IT news, forums, messages
Re: SqlServer 2005: Importing Data: Idenitity fields getting made into non-identities

Posted by Steve on 05/17/07 14:49

On May 16, 6:42 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Steve (tinker...@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.

Our databases have several hundred tables, is there a more practical
solution ( I will talk to my admin and boss about getting service pack
2 )

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация