Taking the Scripts of The Store Procedures in a database via SQL Server JOB

• dakshinamurthy-655138

  SSCertifiable

  Points: 5172

  More actions

  June 19, 2008 at 9:48 am

  #72335

  Hi,

  I need to take the script of all the store procedures and write into a file frequently via SQL Server 2000 job, will you please let me know how to go with this.

  Dakshina

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  June 19, 2008 at 11:32 am

  #831282

  do you mean you want to schedule this? You can right click in EM and script things out.

  If you want this on a schedule, you'll need some DMO automation.

  http://www.sqlservercentral.com/articles/1084/

• dakshinamurthy-655138

  SSCertifiable

  Points: 5172

  More actions

  June 19, 2008 at 10:12 pm

  #831472

  Yes I would like to schedule this, how to go with this.