Ugh, how do I change it? Our production servers are still 2000.
I guess I need to recreate it. Damn, I'm pretty anal about table design and enforcing relationships, fks and so forth. This is like 6 hours of work. > -----Original Message----- > From: Adam Churvis [mailto:[EMAIL PROTECTED] > Sent: Monday, August 27, 2007 10:00 AM > To: CF-Community > Subject: RE: Copy SQL Server DB > > Tim, > > Was the database at Level 80 (2000) compatibility mode? If it was at > Level > 90 (2005) then you won't be able to go backwards with it. > > Respectfully, > > Adam Phillip Churvis > > Get advanced intensive Master-level training in > C# & ASP.NET 2.0 for ColdFusion Developers at > ProductivityEnhancement.com > > -----Original Message----- > From: Loathe [mailto:[EMAIL PROTECTED] > Sent: Monday, August 27, 2007 9:52 AM > To: CF-Community > Subject: Copy SQL Server DB > > >From Express 2005 to 2000? > > This used to be really easy with enterprise manager, but I'm using > express > and the free tools right now. > > Any ideas? The scripts keep bombing out, and the SQL Server 2000 > wouldn't > attach or restore from a 2005 db. > > T > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:241321 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
