Posted by HandersonVA on 10/02/15 11:53

somehow i cannot migrate the database from ms sql 2000 to 2005, i
recreated the same database name and exported the data from 2000 to
2005. THen what happend was all the default values that i set on
tables are not transferred and stored procedures are not transferred.

how can i duplicate the same database in sql 2000 to sql2005 w/o
loosing anything?

[Back to original message]