Post reply

Error running sp_createstats (Cannot insert the value NULL into column 'col_name')

  • March 6, 2014 at 10:04 am

    #284305

    Have you seen this before???

    I'm just running the sp_createstats procedure on a SQL 2012

    Msg 515, Level 16, State 2, Procedure sp_createstats, Line 147

    Cannot insert the value NULL into column 'col_name', table 'tempdb.dbo.#colpostab__________________________________________________________________________________________________________0000000002C1'; column does not allow nulls. INSERT fails.

    The statement has been terminated.

    Any help will be appreciated.

    Thanks,

    Ricardo

  • March 7, 2014 at 1:59 pm

    #1695253

    guest139 (3/6/2014)

    Have you seen this before???

    I'm just running the sp_createstats procedure on a SQL 2012

    Msg 515, Level 16, State 2, Procedure sp_createstats, Line 147

    Cannot insert the value NULL into column 'col_name', table 'tempdb.dbo.#colpostab__________________________________________________________________________________________________________0000000002C1'; column does not allow nulls. INSERT fails.

    The statement has been terminated.

    Any help will be appreciated.

    Thanks,

    Ricardo

    Do you perhaps have XML indexes on any tables in the database that you are running sp_createstats in?

    Jason Wolfkill

  • March 7, 2014 at 2:23 pm

    #1695261

    nope, I dont have any XML index

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

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