saineshwar
Import Database script error
I'm receiving and error while trying to import TicketScriptDB.sql to the SQL 2019 database. Before Creating database i have created SQL Job Store Procedures.
The module 'USP_AssignTickets_Job' depends on the missing object 'Usp_InsertintoTicketStatus'. The module will still be created; however, it cannot run successfully until the object exists. The module 'USP_AssignTickets_Job' depends on the missing object 'Usp_InsertintoTicketStatus_Custom'. The module will still be created; however, it cannot run successfully until the object exists. The module 'Usp_AssignTickettoAgent' depends on the missing object 'Usp_InsertintoTicketStatus'. The module will still be created; however, it cannot run successfully until the object exists. Msg 207, Level 16, State 1, Procedure Usp_InsertAttachmentsDetails, Line 10 [Batch Start Line 6779]
Invalid column name 'AttachmentBytes'.
I'm receiving and error while trying to import TicketScriptDB.sql to the SQL 2019 database. Before Creating database i have created SQL Job Store Procedures.
The module 'USP_AssignTickets_Job' depends on the missing object 'Usp_InsertintoTicketStatus'. The module will still be created; however, it cannot run successfully until the object exists. The module 'USP_AssignTickets_Job' depends on the missing object 'Usp_InsertintoTicketStatus_Custom'. The module will still be created; however, it cannot run successfully until the object exists. The module 'Usp_AssignTickettoAgent' depends on the missing object 'Usp_InsertintoTicketStatus'. The module will still be created; however, it cannot run successfully until the object exists. Msg 207, Level 16, State 1, Procedure Usp_InsertAttachmentsDetails, Line 10 [Batch Start Line 6779]
Invalid column name 'AttachmentBytes'.
HI, from where did you get database script, can you please share??
I'm receiving and error while trying to import TicketScriptDB.sql to the SQL 2019 database. Before Creating database i have created SQL Job Store Procedures.
The module 'USP_AssignTickets_Job' depends on the missing object 'Usp_InsertintoTicketStatus'. The module will still be created; however, it cannot run successfully until the object exists. The module 'USP_AssignTickets_Job' depends on the missing object 'Usp_InsertintoTicketStatus_Custom'. The module will still be created; however, it cannot run successfully until the object exists. The module 'Usp_AssignTickettoAgent' depends on the missing object 'Usp_InsertintoTicketStatus'. The module will still be created; however, it cannot run successfully until the object exists. Msg 207, Level 16, State 1, Procedure Usp_InsertAttachmentsDetails, Line 10 [Batch Start Line 6779]
Invalid column name 'AttachmentBytes'.
HI, Please if you have DB Script please share it, thanks.
