[dba-SQLServer] Moving stored procedures from the Master DB

jwcolby jwcolby at colbyconsulting.com
Thu Jun 4 13:14:07 CDT 2009


 > 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
> 
> 



More information about the dba-SQLServer mailing list