Copy the stored procedures between two MSSQL 2000 servers
Posted on 2003-10-23
I want to copy specified database to another one online Mssql 2000 server.
- Two MSSQL server are not located on same AD, so I could not use "Copy Database Wizard". (no permisson on network)
- I only use "Export data". e.g. database "ABC" export from server A to server B, but it only be copied all tables, not include my created procedures in stored procedures
1. How to copy all by "Export data" ?
2. On the other hand, also how can I do if stored procedure copy only ?