Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error running sp_createstats (Cannot insert the value NULL into column 'col_name') Expand / Collapse
Author
Message
Posted Thursday, March 6, 2014 10:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 2:24 PM
Points: 2, Visits: 35
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
Post #1548368
Posted Friday, March 7, 2014 1:59 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:21 PM
Points: 1,210, Visits: 2,512
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
Blog: SQLSouth
Twitter: @SQLSouth
Post #1548895
Posted Friday, March 7, 2014 2:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 2:24 PM
Points: 2, Visits: 35
nope, I dont have any XML index

Post #1548903
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse