Vista Ultimate, logged as administrator, clean install of latest SQL 2008 RC. Installed VS 2008 with default SQL Express 2005.
Detach 2 DBs from XP SP2 SQL Express 2005 - copy to data folders of two installs of SQL on Vista box
MS 2008 attaches both DBs to SQL Express 2005 on that box, but they are seen as read only. Flipping Read Only prop to false does the trick.
MS 2008 refuses to attach its copies of the DBs to SQL 2008 server - says they are Read-only.
Both DBs re-attach to SQL Express 2005 on the XP box with not problem They are not and have never been read only.
Do I need to attach with CREATE DATEBASE .... TO ATTACH TRUSTWORTHY ON? If there is a programmatic trick I'd very much appreciate help with the syntax as I've never done it this way and can't seem to get it write.
Guidance appreciated
TIA
Charles Hankey
