Scripting Options alter element

• rob.wolters

  Valued Member

  Points: 51

  More actions

  August 11, 2015 at 2:51 am

  #299547

  Hello,

  Is there a way to (automatically) remove/disable the first statements like SET ANSI_NULLS ON and SET QUOTED_IDENTIFIER ON which are generated by modify sp via mms 2014 interface?

  --

  SET ANSI_NULLS ON

  --

  SET QUOTED_IDENTIFIER ON

  ALTER PROCEDURE [dbo].[sp_SendMail] @test-2 INT = 0

  AS

  begin

  --blabla

  end

  Thanks for input!

• Jayanth_Kurup

  SSC-Insane

  Points: 22967

  More actions

  August 11, 2015 at 3:29 am

  #1818827

  Nope dont think so , atleast not within SSMS , might be easier to script out the file and do a replace later.

  You Could use powershell to replace the string if the file is too big.

  Jayanth Kurup[/url]