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 |
|
dhw
Constraint Violating Yak Guru
332 Posts |
 Posted - 2004-12-20 : 17:43:57
|
| Hello...I have a stored procedure that is failing to insert into a table. When I manually run the INSERT statement in SQL QA, I receive the following error message: Server: Msg 208, Level 16, State 1, Procedure ins_C5257449520A4EBDBDF3BBA9F8C9F40E, Line 29Invalid object name 'tsvw_C5257449520A4EBDBDF3BBA9F8C9F40E'."I ran a query against the SysObjects table and there is not a record of the "tsvw.." object..but there is one for the "ins_C525744..." referenced in the first part of the error message. This seems to be related to our replication setup...but I am unsure how to resolve or actually find the problem. I looked at the Stored Procedures list in the database and I can't find one named ins_C5257449520A4EBDBDF3BBA9F8C9F40E. If anyone has any advice or suggestions I'd appreciate it.thanks - dw |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-12-20 : 21:11:37
|
| stupid question:'tsvw_C5257449520A4EBDBDF3BBA9F8C9F40E'Is that a table you're trying to insert into in your statement?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2004-12-20 : 21:29:27
|
| No...as it turns out (and I just figured this one out) that is a reference to an Insert Trigger. For some reason...unknown to me at this moment...there are two Insert Triggers. One is still in the SysObjects table and the one referenced by this error message is not. I backed up my database and deleted the Trigger and now the Stored Proc works like it did before...success! |
|
|
|
|
|
|
Error during Insert - Replication problem?