Post reply

Sql error 1807.

  • January 25, 2009 at 2:32 am

    #932344

    That error indicates that something was using model. Were there any connections or queries to the model database at the time? (including your query that was trying to create the database)

    Oh, and turn auto-close OFF for model.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 25, 2009 at 1:48 pm

    #932433

    Hi

    Thanks for your reply.

    I dont know why it happened as it was a new install.

    I found a solution by writing

    "

    USE model

    GO

    Create database test;

    "

    That seems to have resolve the issue.

    Why I had it in the first place I have no idea as I had just installed SQL 2008 and rebooted once

    Regards

    Morten

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply