Skip to content

Import Database script error #8

@dn250147

Description

@dn250147

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'.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions