I have a C++ application that creates a stored procedure, executes it and
then deletes it. The code works perfectly fine until I change the stored
procedure to a temporary stored procedure by simply prefixing the name with
a pound sign (#).
The error I get is in the first call to SQLDescribeParam:
07009 Invalid Parameter Number
As I said, all is fine if the name of the procedure doesn't start with a #
sign.
SqlDataAdapter.Fill returns results of previous command ... This code executes successfully at certain points in the application, ... I don't know what the cause of this exception is yet, ...stored procedure was indeed executed on the database. ... The trace shows that the last action on the db was the stored ... (microsoft.public.dotnet.framework.adonet)
Re: Help Isolating Data Access ... > I've set up a stored procedure that first queries the table for a record ... > The process that executes this stored procedure runs on multiple threads... Is there a design pattern for ... (microsoft.public.dotnet.general)
Re: Tracing user & permissions (triggers and stored p) ... To solve my problem I chosed to configure the SQL... > from xp_cmdshell executes under the security context of the SQL Server... >> sql Trigger executes a Stored Procedure passing it some variables. ... (microsoft.public.sqlserver.security)
Re: Stored Procedure slow when called from Crystal Reports ...Access executes... that statement to my stored procedure that is executed by the report, ...report runs about 3 times faster - almost as fast as the SP on its own. ... Yes, it is slow the first time, but that's before ... (microsoft.public.vb.crystal)
Re: Executing stored procedures ... I can't post the scripts here due to the amount of data contained.. ... The procedure that executes the Select statement is nestetd to the 4th ...nested stored procedure, this doesnt seem reasonable, or are there some ... > the loop is definately ending, one of the parameters is a load flag, id I ... (microsoft.public.sqlserver.programming)
