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.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Database connection (. MDF) to MSDE 2000

Author  Topic 

yagorik
Starting Member

12 Posts

Posted - 2011-05-26 : 10:03:35
How to attach the database .mdf to MSDE 2000 that was created in MSDE 2000, but once attached to MS SQL 2008 R2. Thanks in advance to all.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-26 : 12:50:10
You can't. Once it got attached to SQL2k8 R2, it was upgraded and therefore can't go back since the products are not forward compatible. Re-attach it to SQL2k8 R2 and then you'll need to export/import everything.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

yagorik
Starting Member

12 Posts

Posted - 2011-05-27 : 03:43:22
When you import an error:
Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'XXFK_AEMsgParamPSXXFRLKEY_XXFXXFR'. The conflict occurred in database 'Demo_test', table 'XXF', column 'XXFR'."
How do I remove a FOREIGN KEY constraint without losing data?
Go to Top of Page

yagorik
Starting Member

12 Posts

Posted - 2011-05-27 : 04:43:21
How to make a script of the database structure without using the Tasks-> Generate Scripts ... from Microsoft SQL Server Management Studio
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-27 : 10:56:47
To remove a foreign key constraint, use ALTER TABLE.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -