Keep Identity

Hi,
Please let me know how to keep identity property retained while copying
empty tables(with identity property set) from one database to another.
One way that I know is Backup\Restore. Suggest some other options.
Thanks in advance...You can try a simple SSIS package using the Transfer SQL Server Object Task
;
look at the Book on line searching for the task and i think you'll be
satisfied.
Gilberto Zampatti
"manu" wrote:

> Hi,
> Please let me know how to keep identity property retained while copying
> empty tables(with identity property set) from one database to another.
> One way that I know is Backup\Restore. Suggest some other options.
> Thanks in advance...|||Hi,
Can't you just script out the table and run the script on the other database
?
You can script using EM in 2000 and Mgmt Studio in 2005.
Thank you.
Regards,
Karthik
"manu" wrote:

> Hi,
> Please let me know how to keep identity property retained while copying
> empty tables(with identity property set) from one database to another.
> One way that I know is Backup\Restore. Suggest some other options.
> Thanks in advance...|||search web for kondredi and get his generate_inserts sproc. WONDERFUL
utility!
TheSQLGuru
President
Indicium Resources, Inc.
"manu" <manu@.discussions.microsoft.com> wrote in message
news:2C6B421A-929F-4FDE-962B-F6000BE1450E@.microsoft.com...
> Hi,
> Please let me know how to keep identity property retained while copying
> empty tables(with identity property set) from one database to another.
> One way that I know is Backup\Restore. Suggest some other options.
> Thanks in advance...