Under SQL Server Management Studio
1)Select all stored procedure
2)Right Click and choose "Script Stored Procedure As"-->"Create to File"
3)save that file with .SQL extention
4)Open the other database and run that .SQL file
Thursday, August 31, 2006
Subscribe to:
Posts (Atom)