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.
| 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 |
|
|
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? |
 |
|
|
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 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Database connection (. MDF) to MSDE 2000