Query Editor SSMS 2008 R2 Strange Script

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Query Editor SSMS 2008 R2 Strange Script

Query Editor SSMS 2008 R2 Strange Script

Rate Topic

Display Mode

Topic Options

Author

Message

webooth

Posted Saturday, October 09, 2010 5:34 PM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, April 29, 2013 11:08 AM
Points: 80, Visits: 579

I just removed SQL Server 2008 Developer and installed SQL Server 2008 Developer R2.

Ever since then if I try to script a stored procedure the procedure script returns bundled in a sp_executesql statement like the one below.

I have never seen anything like this and can't find an option for this anywhere. Any advice is appreciated.

EXEC dbo.sp_executesql @statement = N'--------Procedure Code---------'

Post #1001762

winash

Posted Sunday, October 10, 2010 1:34 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, February 18, 2013 3:46 AM
Points: 1,422, Visits: 1,883

You'll need to modify your SSMS settings.

Go to Tools -> Options and in the left pane choose SQL Server Object Explorer -> Scripting.

In the scripting options go to the "Object Scripting Options" section and set the "Include IF NOT EXISTS clause" to False. The dynamic SQL thingy comes up when this is set to True.

Post #1001779

webooth

Posted Sunday, October 10, 2010 7:14 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, April 29, 2013 11:08 AM
Points: 80, Visits: 579

That did it Exclamation Mark

Thank you very much it was driving me crazy. I had looked at that setting but did not have any idea that's what it did.

Post #1001805

« Prev Topic | Next Topic »

Permissions