Post reply

Scripting the stored proc in sql 2008

  • March 10, 2010 at 1:56 pm

    #217657

    Hi Experts,

    Something is up with my basic settings in sql 2008. When i want to modify the stored proc and/or script it as create/drop.. it comes up embedded in quotes, as string,

    EXEC dbo.sp_executesql @statement = N'ALTER Procedure [dbo].[my_proc]

    as

    how can i make it appear 'normal', please?

    thank you much.

  • March 10, 2010 at 2:36 pm

    #1131658

    Tools-->Options-->SQL Server Object Explorer-->Scripting-->Delimit individual statements

    or can be one of the options in there.

    Thanks,

    Rohan

  • March 10, 2010 at 3:23 pm

    #1131678

    Got it. Works! Thank you so much!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply