Msg 2760, Level 16, State 1, Procedure InsertRecordTo_cvr_upload_SAM_ctl, Line 7"Specified schema name 'msdn' either does not exist or you do not have permission to use it."This is a local database on my computer using a trusted connection as dbo, and I created the msdn schema myself. I have been creating tables and other operations in this schema using the fully qualified name.When I run the below INSERT statement by itself with the commented out values, it runs fine. When I try to create the stored procedure with the parameter line in it (commenting out or removing the test values at the end), it fails with the above error. The error highlights the INSERT statement inside the procedure even though it runs fine by itself. What am I missing?CREATE PROCEDURE msdn.InsertRecordTo_cvr_upload_SAM_ctl @DATA_SOURCE Varchar(4) = 'SAM', @AS_OF_DATE Varchar(6) = 190001, @RECORD_COUNT Int = 1, @QUANTITY_TOTAL Int = 1AS INSERT INTO SoftwareReporting.msdn.cvr_upload_SAM_ctl ( RECORD_COUNT, QUANTITY_TOTAL ) --VALUES (1,2) VALUES ( @RECORD_COUNT, @QUANTITY_TOTAL )GO
One more thing - dbo owns the schema msdn. Thank you.Duane
Specified schema name either does not exist or ...
Posted - 2010-07-07 : 10:57:28
