So I've been working on this VB.NET app that saves to an SQL database for a few weeks now and I've been using various different PCs to write it on (home, work etc). All of these machines so far have had SQL Express 2005 installed on them so I created the database in SQL Management Studio 2005 and have just been taking the most database files with me and attaching them to each PC when I need to. However, I just tried attaching the database to an SQL Server 2000 machine and it wont work... says something about the system index being incorrect - I've googled this and found that a lot of places just say it is because the DB was created in 2005.

So, how can I create a database that will work on all platforms? Is it possible or should I just specify that SQL Server 2005 is needed to run my app?

Cheers
Chris