https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/172615&feed=atom&action=history
Microsoft KB Archive/172615 - Revision history
2024-03-28T11:01:41Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/172615&diff=91636&oldid=prev
3155ffGd: importing KB archive
2020-07-18T15:36:42Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base<br />
|<br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="KB172615"></span>BUG: Sp_cursor: The Parameter 'Table' Is Invalid with Long Database Names =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 172615<br />
<br />
Article Last Modified on 10/3/2003<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* Microsoft SQL Server 6.5 Standard Edition<br />
<br />
<br />
-----<br />
<br />
<div class="notice_section"><br />
<br />
This article was previously published under Q172615<br />
<br />
</div><br />
<div class="notice_section"><br />
<br />
BUG #: 17157 (NT)<br />
<br />
</div><br />
<div class="symptoms_section"><br />
<br />
== SYMPTOMS ==<br />
<br />
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:<br /><br />
<br />
<div class="errormessage"><br />
<br />
Msg 16902, Level 16, State 1<br /><br />
sp_cursor: The parameter 'table' is invalid<br />
<br />
</div><br />
<br /><br />
<br />
<br />
</div><br />
<div class="workaround_section"><br />
<br />
== WORKAROUND ==<br />
<br />
To work around this problem, do any one of the following:<br /><br />
<br />
* Limit the length of your database plus tablename to less than or equal to 28 characters.<br />
* If your application only references one database, reference the table by the tablename, and do not use the database..tablename syntax.<br />
* Have your application use ODBC cursors instead of server side cursors.<br />
<br />
<br />
</div><br />
<div class="status_section"><br />
<br />
== STATUS ==<br />
<br />
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.<br />
<br />
</div><br />
<br /><br />
<br />
Additional query words: table name<br />
<br />
Keywords: kbbug kbprogramming kbusage kbsqlserv650bug KB172615<br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
<span>© Microsoft Corporation. All rights reserved.</span><br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd