Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!

Browse by Tags

All Tags » SQL Server » SSMS   (RSS)

• No Pony
• T-SQL Snack

• T-SQL Snack: Why Does SSMS Generate Create Scripts With EXEC dbo.sp_executesql?

  Introduction I've been meaning to blog about this for a while and a question from a team member prompted this post (thanks Allan!) SSMS Scripting Options In SSMS you can script a stored procedure - right-click a stored procedure, hover over Script Stored Read More... Posted Monday, July 19, 2010 8:00 AM by andyleonard | 9 Comments Filed under: No Pony, SQL Server, SSMS, T-SQL Snack