Copy stored procedures to another database why not?
-
assuming you have 2 SQL2005 database: data1 and data2, I Copy stored procedures from data2 to data1 why not? I want to copy stored procedures through other databases you do?
-
assuming you have 2 SQL2005 database: data1 and data2, I Copy stored procedures from data2 to data1 why not? I want to copy stored procedures through other databases you do?
I assume each database has the same table structure so the stored procedure will actually work! You need to create a script of the stored proc and run the script in each database. Using SSMS right click on the procedure and script as create to a new query window. Then change databases and run the script. Lean how to use the Management Studio!
Never underestimate the power of human stupidity RAH
-
I assume each database has the same table structure so the stored procedure will actually work! You need to create a script of the stored proc and run the script in each database. Using SSMS right click on the procedure and script as create to a new query window. Then change databases and run the script. Lean how to use the Management Studio!
Never underestimate the power of human stupidity RAH
I do not want to create new, I want to Copy stored procedures to another database and to quickly change their
-
I do not want to create new, I want to Copy stored procedures to another database and to quickly change their
Which just reinforces my comment on the above thread, you have no idea what you are doing, get a book and do some reading on how databases work.
Never underestimate the power of human stupidity RAH