[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 occurs 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. Reexecute the failed select into command after increasing the number of locks configuration parameter.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
