Microsoft KB Archive/155767

{|
 * width="100%"|

BUG: Alter Table Within a Stored Procedure Causes Msg 1750

 * }

Q155767

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

SYMPTOMS
When a stored procedure adds a constraint to an existing table using the alter table statement, the following error message appears:

[INTERNAL ERROR] unable to locate original param in voidptr list.

Msg 1750, Unable to create constraint

NOTE: This problem does not occur if alter table is the only command within the procedure text. A simple If condition, such as 'if @@error,' following the alter table statement causes the problem to occur.

WORKAROUND
Declare a local variable and assign the alter table statement to the variable. Use the Exec statement for execution.

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

Additional query words: TABLE INTERNAL ERROR

Keywords : kbnetwork

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600