Matt Miller (#4) (5/25/2014)
Have you tried look at the profiler session of the parameters being passed in? Also - have you made sure that there is in fact only ONE stored proc with that specific name (e.g. myuser.StoredProc and dbo.StoredProc)? If the ASP is using a specific user account it might not be using the default schema.On profiler: start a session recording, then fire your ASP call at it - you should be able to see what it being passed in.
I don't think I can use profiler. My site and database are on a shared hosting service and concerning SQL Server I am sometimes severely hamstrung. There have been many scripts for querying performance and certain DBA type jobs that I have tried to run only to get the "You do not have permission for that function" message.
Luckily, this issue has been resolved. But thank you!
Dana