[CR #397910] If an attempt to create a new table using select into fails, a subsequent dbcc checkcatalog in the target database might run into errors reporting on missing rows between syscomments and sysprocedures. This error occurs for the definition-time table that was created as part of the previously failed select into statement. One common instance of such failures is insufficiently configured number of locks parameter, which can result in a 1204 error message, indicating an insufficient number of locks.
Workaround: Drop the table referenced by its object ID in the error message. Then, re-execute the failed select into command by increasing the number of locks configuration parameter.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
