Hello,
I'm having trouble figuring out how to transfer tables from a SQL2000
database into a SQL 2005 database and bring over extended properties like
identity columns, default values, etc. The DTS wizard in SQL 2000 had a
simple checkbox that said "Include extended properties". I'm having a heck
of a time finding anything like that in 2005. Can someone give me a shove in
the right direction?

Thanks,
Barb