[CR #397910] If an attempt to create a new table using select into fails, a subsequent dbcc checkcatalog in the target database may generate errors on missing rows between syscomments and sysprocedures. These errors occur for the definition timetable that was created as part of the previously failed select into statement. One common instance of such failures is an insufficiently configured number of locks parameter, which can result in a 1204 error message.
Workaround: Drop the table referenced by the object ID in the error message. Re-execute the failed select into command after increasing the number of locks configuration parameter.