Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itsmarkdavies
Starting Member
14 Posts |
 Posted - 2002-02-27 : 03:41:11
|
| CAN ANYONE TEL ME THE BEST WAY TO MOVE STORED PROCEDURES FROM THE master DATABASE ON ONE SERVER TO THE master DATABASE ON ANOTHER SERVER ?ARE THERE ANY SPECIAL CONSIDERATIONS TO BEAR IN MIND WITH IT BEING THE master DATABASE ?THANKS FOR YOUR HELP |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-02-27 : 09:24:05
|
| When you install sql server all the system stored procedures should be created.If you have place user stored procedures in master then maybe you should consider whether it is a good ideas.Moving is same as any other dtabase - just script them off and apply the script to the destination. Easy if you keep the scripts in SourceSafe which I would recommend.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Moving Stored Procedures