| Subject | SET GENERATOR in a stored procedure | 
|---|---|
| Author | Tim Ledgerwood | 
| Post date | 2003-05-13T08:01:01Z | 
Why can't I do this, and how would I achieve the same thing if I can't do it :
ALTER PROCEDURE MYPROCEDURE
(
INPUT PARAMETER LIST
)
RETURNS
(
OUTPUT PARARAMETER LIST
)
AS
BEGIN
SET GENERATOR GEN_MYGENERATOR TO 0;
.
.
.
END
[Non-text portions of this message have been removed]
            ALTER PROCEDURE MYPROCEDURE
(
INPUT PARAMETER LIST
)
RETURNS
(
OUTPUT PARARAMETER LIST
)
AS
BEGIN
SET GENERATOR GEN_MYGENERATOR TO 0;
.
.
.
END
[Non-text portions of this message have been removed]