Using Stored Procedure for <Action> element instead of Inline TSQL -- sql server notification services

Steve Youmans
6/29/2004 10:08:28 AM

You access a stored procedure by doing the following
<ACTION>
EXEC storedprocedurename
</ACTION>

You must use the EXEC statement in front of the stored
procedure in order for it to work.
[quoted text, click to view]

Joe Webb
7/6/2004 7:14:24 AM

Clint -

Implicit in Steve's response is that you create and maintain the sproc
outside of the SQLNS framework. As such, you'll need to make sure that
when/if you change the SQLNS app using NSControl, any corresponding
changes required to the sproc will need to be done outside the build
process.

HTH....
Joe Webb

[quoted text, click to view]

Colin Meek [MSFT]
8/19/2004 1:40:43 PM

The chronicle nodes in the ADF are versatile. You can use them to create
stored procedures as well as tables, so that a separate step is not required
to deploy your instance.

-Colin

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

Please do not send e-mail directly to this alias. This alias is for
newsgroup purposes only.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server notification services

sql server notification services : Using Stored Procedure for <Action> element instead of Inline TSQL