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.