INF: ODBC Stored Procedures odbc#userid######## on SQL ServerLast reviewed: September 9, 1996Article ID: Q115907 |
The information in this article applies to:
SUMMARYWhen an ODBC enabled application uses prepared execution to execute an SQL query on SQL Server and the user has permission to create stored procedures, the ODBC SQL Server driver creates a stored procedure with a name like "odbc#userid########" (for example, odbc#sa2147024896) on SQL Server and executes that stored procedure. The stored procedure is created in response to a SQLPrepare ODBC call and is executed when SQLExecute is called. Normally, when the connection is closed, the driver drops these stored procedures. Also, if the user does not have Create Proc permissions, the stored procedures are not created and SQL statements are executed directly. However, under certain situations when a connection might be terminated without closing the connection, the driver is not able to delete the stored procedures. This can happen if the client process terminates abnormally and is a more common occurrence in a development environment. This article describes how to remove these stored procedures from the SQL Server.
MORE INFORMATIONTo remove these stored procedures, follow these steps. Make sure no ODBC client is connected to the server when the following steps are carried out.
|
KBCategory: kbusage
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |