Hi,

I made that change to the default database to USer Login from Master to production as you suggested and it solved the problem with the stored procedure not found errro...

Thanks for your suggestion. I am going to make this change and hopefully it will solve our problem.

Thanks for your reply. Should I change the User's default database as the Production database. Will this solve the problem.

Your time and suggestions are highly appreciated.

Martha

The User connects to the production database. There is only one database that the user connects and all tables & stored procedures are on that database ONLY. So there is...