Script Generation without SET QUOTED_IDENTIFIER OFF

[karthik555]

Hello!

I am generating script for all the Stored Procedures in the DB.

I have the following text before each SP script.

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

How do I supress this?

Thanks in adavnce.

 

[amrita418]

You can try something like this:

select replace(@v_name,  'SET QUOTED_IDENTIFIER OFF', '')

Regards,
AA

 

[karthik555]

Your solution is for replacing the text in the script which is already generated.

I want to know if there is any setting in Enterprise Manager to supress this.

Regards
Karthik

 

[vongrunt]

If you suppress these settings, stored procedure generated with script may not behave the same way as original.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[karthik555]

Thanks for that info. It was an eye opener!

Your are right. If I supress them some 90% of my SPs may not work.

Thanks again.

Karthik