Question about scripting out of stored procedures

• SQL Guy 1

  SSCoach

  Points: 15981

  More actions

  July 28, 2010 at 3:04 pm

  #387456

  In SSMS in Database/Tasks/Generate script we can generate scripts for given objects. This wizard scripts stored procedures with EXEC dbo.sp_executesql @statement = N'create stored procedure......'

  I need to get straight statement like

  create stored procedure ...

  What settings should I set for this ?

  Thanks

• torpkev

  SSCarpal Tunnel

  Points: 4819

  More actions

  July 28, 2010 at 3:21 pm

  #1199513

  Perhaps this link from @AndyLeonard will help

  http://sqlblog.com/blogs/andy_leonard/archive/2010/07/19/why-does-ssms-generate-create-scripts-with-exec-dbo-sp-executesql.aspx

  --------------------------

  I long for a job where my databases dont have any pesky users accessing them 🙂