October 31, 2005 at 5:51 pm
Has anyone ever seen this error before when running sp_createstats on all tables in a database - and if so do you know what it means!!
Server: Msg 515, Level 16, State 2, Procedure sp_createstats, Line 99
Cannot insert the value NULL into column 'col_name', table 'tempdb.dbo.#colpostab__________________________________________________________________________________________________________0001001398DC'; column does not allow nulls. INSERT fails.
The statement has been terminated.
November 3, 2005 at 8:00 am
This was removed by the editor as SPAM
June 14, 2011 at 11:28 am
Hmm...this is an old one...and still no response from anyone. Matches my issue perfectly....no banana. :ermm:
One tequila, two tequila, three tequila, floor.
June 14, 2011 at 11:43 am
waynejohn (6/14/2011)
Hmm...this is an old one...and still no response from anyone. Matches my issue perfectly....no banana. :ermm:
Go in master, open up the sp in question. Copy the code to QA and run manually untill you hit the error.
I'd bet it's something weird like unsynchronised user id or something similar that makes it crash.
I'd make sure I' on SP4... just in case.
June 14, 2011 at 12:24 pm
Thanks, will give that a go.
One tequila, two tequila, three tequila, floor.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply