Does ADO.NET TableAdapters cache stored procedure names in a super secret location

Question

I'm guessing Visual Studio is bugging out on me. I changed the stored procedure the a TableAdapter query uses and now the users keep getting the following error.

Procedure or function 'usp_GetEventNotificationSubscribers' expects parameter '@FacilityCode', which was not supplied.

Nowhere in the application is 'usp_GetEventNotificationSubscribers' written.

I can't reproduce the error on my local machine. When I run it locally or step through it in debug mode everything works fine. It even works for me in production. But I keep getting them auto-emailed to me whenever it happens, which is about 3 a day.

Answer 1

Is the proc being referenced from another proc in the database? If this is so, you won't find the string in your application source code.

try this:

SELECT * FROM SYS.Comments WHERE text LIKE '%GetEventNotificationSubscribers%'

Answer 2

Is the stored procedure different (e.g. with different parameters) at the production site? It might be that the proc was updated/altered there and locally at your dev environment you're working with a different procedure. This error seems to suggest that the proc in the sqlserver db at the production site has more parameters than the one at your development database.

Answer 3

A few users where still using the test version of the site. I denied access to everyone on the test virtual directory and the error ceased.

Thanks Noel