New to this forum and this is my first post. I am new and way out of my class and hoping someone can help with my current problem. I am using a contact management program called "Wired Contact" and resently moved the database files to a new faster server and upgraded from SQL 2000 to SQL 2005. I am getting the below error. The only difference that can be seen is that when the user database was setup the name was change from "WCUser" to "WCuser" would this be case sensitive? or any other help. THANK YOU!
Could not find stored procedure 'spSelectWCECompanyStatus'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'spSelectWCECompanyStatus'.
Line 107: cmd4.CommandType = CommandType.StoredProcedure; Line 108: cmd4.Parameters.Add("@actid", actid); Line 109: SqlDataReader reader4 = cmd4.ExecuteReader(); Line 110: reader4.Read(); Line 111: CompanyName = reader4.GetString(0);
Please can you check the server collation on both the server instances. to check SQL server instance collation using SSMS, right click the instance name, select properties, in the properties window - general section look for "server collation" value.
Compare the collations at the instance level or at the database level and determine whether the upgraded system is using a case sensitive collation.
Thank you VERY much for these helps and I will do and report back. So is the general consensus is that it is not because I moved from 2000 to 2005 that creates this problem and have to go back to 2000?