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 |
|
cbecerra
Starting Member
38 Posts |
 Posted - 2002-02-26 : 18:18:25
|
| I was wondering if anyone knew how to exec a xxxxx.sql script from within a store procedure. To be more precise, using EM I generated an xxxxx.sql script of a store procedure. Now I want to generate that same store procedure but from within a store procedure I created. Can this be done.Thanks |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-02-26 : 19:16:42
|
HiYes there is a good way to dp this. But you have to buy the new Ken Henderson book The Guru's Guide to SQL Server Stored Procedures, XML and HTML to get it  (Are you proud Rob ? )Essentially, Ken has some code that he uses sp_OACreate in a stored proc to call SQL DMO to script the procedure. No, I'm not going to post that code.Damian |
 |
|
|
cbecerra
Starting Member
38 Posts |
Posted - 2002-02-27 : 12:38:57
|
| I actualy have the book, and in fact a modefy the procedure to create my xxxx.sql scripts. However creating the scripts is not the problem, is exec them from within a store proc that I'm having problems with. The book makes no mention on how this can be done. |
|
|
|
|
|
|
SQL script