Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
feejaz
Yak Posting Veteran
68 Posts |
 Posted - 2007-12-27 : 03:26:28
|
| Hi,I have a database that was made in sql2000. Now I want to working in sqlexpress 2005. What should do to chande this database in sqlexpress 2005. I want to run this database with asp.net 1.1Thanks.Navi |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-12-27 : 03:58:38
|
| first create the database in 2005 with compatibility level sql server200(80)then take the backup from sql2000 server.restore the backup in 2005 with force restore on existing database.there is nothing more to changeVinodEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
|
|
|
sql2000 ang sqlexpress2005