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 |
|
Onamuji
Aged Yak Warrior
504 Posts |
 Posted - 2001-03-28 : 09:03:25
|
Ok, for those of you familar with MS Project 98's interface with SQL Server here we go... on the production box everything works perfectly fine, but on the developer box it gets this error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'Project_Information' with unique index 'i_Project_Information'. I know exactly where it's happening we have a procedure called pCreateProject which creates a new project with a template that is stored in the database. Pretty straight forward code, but I can run this query with the parameters I send it through a ADODB.Command object and it runs fine except ADO FAILS EVERYTIME... so I though maybe DTS didn't copy the database over correctly so after 6 hours of waiting (it's a 1.5gb database) I found out DTS was failing for some messed up reason. Well so I backuped the database copied it to the developer box and restored it from there... all the data was transfered correctly except I am STILL getting this error. The code is really straight forward. and it's not ADO that is failing is the procedure but for some reason... it shouldn't be... because I can run the procedure with EXACT same parameters from ISQL and it's fine.... Please help, my development box is possessed!!!  Regards,Adam |
|
|
|
|
|
Removing Unique Indexes