Script failed for StoredProcedure "dbo.XXX"

• vijay-388587

  SSC Veteran

  Points: 228

  More actions

  January 31, 2012 at 9:21 am

  #256015

  Hi,

  I am getting below error while trying to read stored procedure script from database using SMO.

  Script failed for StoredProcedure

  at Microsoft.SqlServer.Management.Smo.SqlSmoObject.EnumScriptImpl(ScriptingOptions so)

  at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ScriptImpl(ScriptingOptions so)

  at Microsoft.SqlServer.Management.Smo.StoredProcedure.Script()

  Please help me in solving this.

  Thanks,

  Vijay

• johnitech.itech

  Hall of Fame

  Points: 3252

  More actions

  February 1, 2012 at 6:04 am

  #1441169

  😀

  check link

  http://connect.microsoft.com/SQLServer/feedback/details/487013/scripting-via-smo-in-multithreaded-application-iscriptable-script-fail-in-sqlsmoobject-getquerytypekeyfields

• speednick

  SSC Journeyman

  Points: 77

  More actions

  November 22, 2012 at 1:19 am

  #1561513

  I had the same problem.

  The reason was in the comments placed before the "CREATE/ALTER PROCEDURE" command.

  There was this kind of comments:

  /*

  sql stuff

  /*

  sql stuff

  */

  sql stuff

  */

  So, I cleaned by removing the inner comment leaving the following:

  /*

  sql stuff

  */

  This solved the problem.

  HTH