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 HELPThis sounds familiar - you wouldn't be posting on multiple sites would you?
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment