I am the administrator for the database. I have a database with 21 tables and 65 stored procedures that were created in SQL Server 2005 and all work flawlessly. I recently installed SQL Server 2008 R2 Enterprise and imported all the data and stored procedures.
Everything still works fine.
I created a new stored procedure and it creates fine and I can see it in the databases stored procedures along with the others. When I go to modify the stored proc, the code comes up fine, but I get the red error underline and shows the error "Invalid
object name 'dbo.Import_SymbolsNames'." I can ALTER the sproc and it still saves it. If I try to run the sproc, it does nothing, I get a return value of 0 and I get the error "Could not find the stored procedure 'dbo.Import_SymbolsNames'. Not
sure what's going on here, maybe a config problem. I tried it with an existing sproc and changed the name with the same results. It's a very simple bulk insert routine. Below is the code.
View Complete Post