Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/172615

From BetaArchive Wiki
Knowledge Base


BUG: Sp_cursor: The Parameter 'Table' Is Invalid with Long Database Names

Article ID: 172615

Article Last Modified on 10/3/2003



APPLIES TO

  • Microsoft SQL Server 6.5 Standard Edition



This article was previously published under Q172615

BUG #: 17157 (NT)

SYMPTOMS

If a client application references a table using the database..tablename syntax and requests server side cursors, (not a Transact-SQL ANSI cursor) the following error will occur when performing an insert into the database..tablename, if the combination of database plus tablename is greater than 28 characters:

Msg 16902, Level 16, State 1
sp_cursor: The parameter 'table' is invalid



WORKAROUND

To work around this problem, do any one of the following:

  • Limit the length of your database plus tablename to less than or equal to 28 characters.
  • If your application only references one database, reference the table by the tablename, and do not use the database..tablename syntax.
  • Have your application use ODBC cursors instead of server side cursors.


STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.


Additional query words: table name

Keywords: kbbug kbprogramming kbusage kbsqlserv650bug KB172615