Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating stored procedures with sqlExec()
Message
 
 
To
13/05/2004 08:49:55
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00903526
Message ID:
00903536
Views:
23
This message has been marked as a message which has helped to the initial question of the thread.
Jörg,

Don't include 'GO'. It's not a T-SQL statement but Query Analyzer batch separator. Only QA recognize it.

>Hi Sergey,
>
>aerror is telling me somthing about 'too few arguments'! The procedure contains just this:
>
>CREATE PROCEDURE dbo.sp_DisableTrigger @tnOnOff numeric=1 AS
>begin
>
>end
>GO
>
>This procedure is stored in an local variable t and I try to send it with
>sqlExec(h,t), where h is containing the handle.
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform