Francisco Tapia
fhtapia at gmail.com
Thu Jun 4 13:16:32 CDT 2009
Easiest way would be to save them all to a file, then you can copy all of them and drop them in as one command and re-create all your sprocs in one motion... -Francisco http://sqlthis.blogspot.com | Tsql and More... On Thu, Jun 4, 2009 at 11:14 AM, jwcolby <jwcolby at colbyconsulting.com>wrote: > > using management studio you can script each one out. > > Directly into the other database? To a file and move the file? I know how > to deal with database > files but not things like stored procedures. > > John W. Colby > www.ColbyConsulting.com > > > Francisco Tapia wrote: > > using management studio you can script each one out. > > > > -Francisco > > http://sqlthis.blogspot.com | Tsql and More... > > > > > > On Thu, Jun 4, 2009 at 10:31 AM, jwcolby <jwcolby at colbyconsulting.com > >wrote: > > > >> I have a dozen or so stored procedures in the master database. I am > >> rebuilding my servers and need > >> to move those stored procedures to the Master db on the other server. > How > >> do I do this? > >> > >> -- > >> John W. Colby > >> www.ColbyConsulting.com > >> _______________________________________________ > >> dba-SQLServer mailing list > >> dba-SQLServer at databaseadvisors.com > >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > >> http://www.databaseadvisors.com > >> > >> > > _______________________________________________ > > dba-SQLServer mailing list > > dba-SQLServer at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > http://www.databaseadvisors.com > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >