Table not found error when you know it exists? Check your triggers

Credit for this goes to my buddy Lance Staples, who is somewhat of a Luddite when it comes to blogs/social media/etc. I was testing a simple ColdFusion form process that kept throwing a database error saying that a table did not exist. I checked my database and it was there so I wasn’t quite sure what the issue was. Then I noticed the error said the table was 1stcomp.dbo.table. In this form, “1stcomp” is the database. In my local copy of the database I had used FirstComp for the name. Easy enough to fix - right? Check the SQL. But I noticed in the error that even the SQL wasn’t using a fully qualified name. It just used “table”. So what the frack, right?

I noticed that the table being complained about, let’s call it douchepickle, wasn’t the same table in the query, let’s call it catfryingpan. I mentioned this to Lance who remembered that a trigger was in play here. Inserts into catfryingpan ran a trigger and in that SQL the calls to douchepickle were qualified with 1stcomp.dbo.

I’ll be honest - I’ve never written a trigger in my life. I know what they are for of course, but I certainly never though to check in there. Hopefully if this happens to you this blog entry will be helpful!

Raymond Camden's Picture

About Raymond Camden

Raymond is a developer advocate looking for his next gig. He focuses on JavaScript, serverless and enterprise cat demos. If you like this article, please consider visiting my Amazon Wishlist or donating via PayPal to show your support.

Lafayette, LA https://www.raymondcamden.com

Comments