HOWTO: Script object as execute?

(Didn't know in wich group this question belongs....)
Hi group,

In QA there is an option called 'Script object as....' Were developing a lot of sp's.
When I use this option the 'skeleton' of a sp is created.
Eg
Create proc uspMySP
@Message varchar(10)
AS
SELECT @Message

The mention option would generate the following:
DECLARE @RC int
DECLARE @Message varchar(10)
-- Set parameter values
EXEC @RC = [EMGLSP3].[EM3_OWN].[uspMySP] @Message

The question:
Is it possible to customize this I would like to *** SET statements...
Is this possible

Regards
Sander

Answer this question

HOWTO: Script object as execute?

jbaynham
Thnx! As I said...I didn't know where to post this question.
Butterfly Boy
AFAIK, you cannot customize the scripting output of QA (other than the high-level knobs). You might want to ask this question in the Tools forum also since this is not a Transact-SQL one.
SPDOTNET
It is possible to add/modify the QA templates.

Here's an article on the subject.
http://www.sqlservercentral.com/columnists/glarsen/usingqueryanalyzertemplates.asp

=;o)
/Kenneth
woodland30033
No, that's not what I want. Those templates can be used for creating a sp. I've already got a SP and I do not want to add the SET statements every time.

Thnx anyway!
HOWTO: Script object as execute?

Answer this question