How to use xp_get_script from t-sql

• Prakash Sawant

  SSCrazy

  Points: 2173

  More actions

  January 4, 2008 at 9:19 am

  #119596

  Hi,

  I am trying to generate create object script from t-sql and came across this undocumented “xp_get_script” procedure, can anybody please tell me how to get the script for a given object by using this procedure?

  Thanks,

  ------------
  Prakash Sawant

  http://psawant.blogspot.com

• SanjayAttray

  SSChampion

  Points: 13157

  More actions

  January 4, 2008 at 9:39 am

  #764887

  Try this. Its working good for me. Create this proc in you current database.

  CREATE PROCEDURE sp_get_script @name sysname

  AS

  BEGIN

  exec master.dbo.xp_get_script @name

  END

  SQL DBA.

• Prakash Sawant

  SSCrazy

  Points: 2173

  More actions

  January 4, 2008 at 9:43 am

  #764890

  I have tryed that, but not able to get any script out.

  just getting below error.

  Msg 22047, Level 16, State 0, Line 0

  Error executing xp_get_script extended stored procedure: Specified resource name could not be found

  ------------
  Prakash Sawant

  http://psawant.blogspot.com