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 |
|
layfnatu
Starting Member
2 Posts |
 Posted - 2004-08-26 : 16:01:47
|
| I had a strange error occur using query analyzer (QA) that I have never seen before, there wasn't even one hit on Google so I hope I can get some help here. We are using SQL Server 2000I ran the following statement QA UPDATE ACCOUNT SET CNTL_YEAR = NULL WHERE CNTL_YEAR = '0000'and received the following errorServer: Msg 2812, Level 16, State 62, Line 617Could not find stored procedure 'SP_CHANGEEVENTS'.The statement has been terminated.As you can see there's nothing special about the statement. The Column CNTL_YEAR is of type varchar(4) with nulls allowed. I tried to run the statement from multiple computers but always encountered the same error message. When the same statement was run in Enterprise manager, it went through just fine.Any thoughts? Also, I don't know what SP_ChangeEvents is let alone why it would be called. Your help in understanding this problem would be greatly appreciated SQL Server 2000 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-26 : 16:04:07
|
| Got an update trigger on Account table?Tara |
 |
|
|
layfnatu
Starting Member
2 Posts |
Posted - 2004-08-26 : 16:18:39
|
| As a matter of fact yes, 3 of them. Good thinkin. This was an update that was requested to be run by the vendor of the product, they didn't mention anything about triggers. I was about to repost that the problem also occurred in Enterprise manager on the second update using the exact same statement in a different database. Thank you Tara for your quick response. You were very helpful. |
|
|
|
|
|
|
Query Analyzer Error