I'm getting the pageaudit error when I try to attach a database from SQL 2000 to MSDE, using sp_db_attach
I am aware from previous discussions that this problem is caused by copying databases from the 2000 series to the 7 series.
The problem is that I need to be able to copy databases between different versions as we have clients with everything between 6.5 and 2000, and we will probably have some with XP soon (although we probably won't need to do the attach on any new 6.5 servers). We also want to demonstrate our software by distributing a trial version using the MSDE.
Has anyone worked out a could way of copying databases between different versions? Can one attach a 7 database to a 2000 server? or is it a problem whichever direction you go in?