Could not find stored procedure ‘proc…’.

If you get an error message such as:

A database error occurred: Could not find stored procedure ‘procDescriptionAssert’.

It could be due to an “ownership” issue.

Use SQL Server Management Studio Express (or similar tool) to see if it is owned by something other than “dbo”. If so, you could change it with a command similar to:

ALTER SCHEMA dbo TRANSFER [ACME\JohnQ].procDescriptionAssert  
go

Change [ACME\JohnQ] to whatever you see before the period (unless it is already “dbo”).

The problem with the incorrect schema most likely occurs because your user account in the database has has the default schema set to your account instead of dbo. You can check that by bring up Properties on the user in SSMS. The default schema should be null, which is then interpreted as dbo. The user interface will not allow you to change the default schema to null and neither will the ALTER USER command. The only way we’ve found to make the default user null is to delete and recreate the user, leaving the Default Schema blank.