Thanks for the help. I discovered GO just after I had asked the question. 

David Cameron
nOw.b2b
dcameron@i...


-----Original Message-----
From: Roland Boorman [mailto:r_boorman@y...]
Sent: Friday, 18 May 2001 12:40 AM
To: sql language
Subject: [sql_language] RE: moving stored procs


I find this very interesting

This is my approach using Access

The idea is to recreate the text files that generated the 

Proc

The idea is to create and use a Pass thorough queries using   
Sp_help  for list of the Procs

and then a second  passthrought query 

you need to change this second Query.sql =Sp_Helptext ' proc name' 

taking the proc name from above.

The resulting query is a table records hold the Proc text details

print it email it do what you like with it.

better still if you can link to the second SQL Server then 

use another pass through query 

iterate through the second query above to build sql

execute 'results of Sp_Helptext above'

get the idea It works 


  Brian Matsik <brianmat@o...> wrote: 
Do you issue a GO after the CREATE PROC?

Brian Matsik, MCSD/MCT
President and Senior Consultant
Object Oriented Consulting Services, Inc.
www.oocs.com