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---------'