Post reply

Error while creating DB

  • December 2, 2014 at 3:44 am

    #292580

    Hi,

    I was preparing a script for creating DBs, jobs and alerts. It was working fine earlier.

    Today I dropped all those existing objects and tried to create it using script.

    But it failed with the attached error... Please help. Thanks !!

    Smith.

  • December 2, 2014 at 3:58 am

    #1761990

    You have a server-scoped DDL trigger on CREATE DATABASE?

    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

  • December 2, 2014 at 6:38 pm

    #1762260

    GilaMonster (12/2/2014)

    You have a server-scoped DDL trigger on CREATE DATABASE?

    Yes Gila. I have enabled DDL trigger for auditing purpose. It inserts a record into one of the table in that database which is dropped already.

    Thanks a lot Gila..!!

  • December 3, 2014 at 1:12 am

    #1762278

    Joy Smith San (12/2/2014)

    I have enabled DDL trigger for auditing purpose. It inserts a record into one of the table in that database which is dropped already.

    Hence will be failing, hence will make the CREATE DATABASE fail.

    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

  • December 3, 2014 at 7:02 pm

    #1762563

    Rectified the issue. Thanks a lot Gila...!

Viewing 5 posts - 1 through 4 (of 4 total)

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