Skip to content

Error when running the SquiggleHistory.sql file | SQL Server version 11.0.2218. #14

@vanny1980

Description

@vanny1980

Hi,
When i run the SquiggleHistory.sql file once I've logged into Management Studios. I get the following error.

Msg 911, Level 16, State 1, Line 1
Database 'SquiggleHistory' does not exist. Make sure that the name is entered correctly.

After reading the WIKI i was to believe this would create the SquiggleHistory database. But it did not do that. Now when i run that command again. It now shows me the following errors.

Msg 911, Level 16, State 1, Line 1
Database 'SquiggleHistory' does not exist. Make sure that the name is entered correctly.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Events' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Participants' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Sessions' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'StatusUpdates' in the database.
Msg 2714, Level 16, State 5, Line 1
There is already an object named 'FK_dbo.Events_dbo.Sessions_SessionId' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 5, Line 1
There is already an object named 'FK_dbo.Participants_dbo.Sessions_SessionId' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.

Can you please confirm where it's creating these objects if the Database "SquiggleHistory" does not exist.

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