When I execute the CanvasDataStore_mmddyy_hhmm.sql file, the query will output the below error messages. I can verify that all of the Stored Procedure tables and the one Scalar-valued Function is there. When the dbo.CanvasData_General_DownloadSchemaAndTables file is run, it creates 8 different outputs that return mostly Null values. I'm not sure how to troubleshoot since I've tried re-creating the database multiple times. I've added this image under the error messages below.
Thank you,
-Alex
Msg 3701, Level 11, State 5, Line 4
Cannot drop the procedure 'dbo.CanvasData_General_TableBuild_06_CreateIndexes', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 7
Cannot drop the procedure 'dbo.CanvasData_General_TableBuild_05_DropImportTables', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 10
Cannot drop the procedure 'dbo.CanvasData_General_TableBuild_04_LoadProductionTables', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 13
Cannot drop the procedure 'dbo.CanvasData_General_TableBuild_03_CreateProductionTables', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 16
Cannot drop the procedure 'dbo.CanvasData_General_TableBuild_02_LoadImportTables', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 19
Cannot drop the procedure 'dbo.CanvasData_General_TableBuild_01_CreateImportTables', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 22
Cannot drop the procedure 'dbo.CanvasData_General_TableBuild_00_CreateCanvasDataTableFields', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 25
Cannot drop the procedure 'dbo.CanvasData_General_TableBuild', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 28
Cannot drop the procedure 'dbo.CanvasData_General_DownloadSchemaAndTables', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 31
Cannot drop the table 'dbo.RAWSchemaVal', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 34
Cannot drop the table 'dbo.RAWSchemaKey', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 37
Cannot drop the table 'dbo.CanvasDataTypeCrosswalk', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 40
Cannot drop the table 'dbo.CanvasDataTableFields', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 43
Cannot drop the table 'dbo.CanvasDataRawSchema', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 46
Cannot drop the table 'dbo.CanvasDataFieldExceptions', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 49
Cannot drop the function 'dbo.udf_GetNthCharacterOccurrence', because it does not exist or you do not have permission.
When I execute the CanvasDataStore_mmddyy_hhmm.sql file, the query will output the below error messages. I can verify that all of the Stored Procedure tables and the one Scalar-valued Function is there. When the dbo.CanvasData_General_DownloadSchemaAndTables file is run, it creates 8 different outputs that return mostly Null values. I'm not sure how to troubleshoot since I've tried re-creating the database multiple times. I've added this image under the error messages below.
Thank you, -Alex
Msg 3701, Level 11, State 5, Line 4 Cannot drop the procedure 'dbo.CanvasData_General_TableBuild_06_CreateIndexes', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 7 Cannot drop the procedure 'dbo.CanvasData_General_TableBuild_05_DropImportTables', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 10 Cannot drop the procedure 'dbo.CanvasData_General_TableBuild_04_LoadProductionTables', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 13 Cannot drop the procedure 'dbo.CanvasData_General_TableBuild_03_CreateProductionTables', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 16 Cannot drop the procedure 'dbo.CanvasData_General_TableBuild_02_LoadImportTables', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 19 Cannot drop the procedure 'dbo.CanvasData_General_TableBuild_01_CreateImportTables', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 22 Cannot drop the procedure 'dbo.CanvasData_General_TableBuild_00_CreateCanvasDataTableFields', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 25 Cannot drop the procedure 'dbo.CanvasData_General_TableBuild', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 28 Cannot drop the procedure 'dbo.CanvasData_General_DownloadSchemaAndTables', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 31 Cannot drop the table 'dbo.RAWSchemaVal', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 34 Cannot drop the table 'dbo.RAWSchemaKey', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 37 Cannot drop the table 'dbo.CanvasDataTypeCrosswalk', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 40 Cannot drop the table 'dbo.CanvasDataTableFields', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 43 Cannot drop the table 'dbo.CanvasDataRawSchema', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 46 Cannot drop the table 'dbo.CanvasDataFieldExceptions', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Line 49 Cannot drop the function 'dbo.udf_GetNthCharacterOccurrence', because it does not exist or you do not have permission.