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]
|