What did I customize? Query designer now using sp_executesql @statement

SQL Server Tools General

LadySQL


I may have Customized how my views are but cannot find where to "turn it off".

In SQL Server Management Studio

[select a stored procedure] --> right Click --> Modify

My SP's look like this now:

Code Snippet

EXEC dbo.sp_executesql @statement = N'ALTER PROCEDURE [db

in stead of

Code Snippet

ALTER PROCEDURE [dbo].[Pricing_3ItmNotOnPricing_SP] @Keep AS BIT

AS

What did I do


Top

Re: What did I customize? Query designer now using sp_executesql @statement

Caddre


You just need to change your options from modify to script view as and choose ALTER to a new query window. Hope this helps.






Top

Re: What did I customize? Query designer now using sp_executesql @statement

LadySQL

I am sorry, the "alter in new query window" wasn't the approach I found.

Asked a buddy & he said it was this:

Inside SQL Server Management Studio (for SQL Server 2005):

Tools --> Options --> Scripting --> Include IF NOT EXISTS clause must be FALSE

or your scripting will be concatenated into:


Code Snippet

EXEC dbo.sp_executesql @statement = N'ALTER PROCEDURE [dbo].[MyStoreedProc]

AS INSERT INTO dbo.

When it is false, it will look like this:

Code Snippet

ALTER PROCEDURE [dbo].[MyStoredProc]

AS

INSERT INTO dbo.MyTable...






Top