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 |
|
Victoria
Starting Member
1 Post |
 Posted - 2007-03-13 : 05:58:10
|
| Hello,I have my script split into several sql files: I have my procedure scripts in one set of files, and I have the so-called 'main.sql' file that contains the commands to create those procedures. What I am trying to do is make sure I only need to run the 'main' sql, and all procedures from other .sql files will be created from my 'main.sql' file.Problem: when I try and call 'CREATE PROC' from 'main.sql', it naturally complains that it can't find the body of the proc. Is there a way to tell the 'main' where to look for the implementations of those procedures at all?Looking forward to any suggestions, both SQL script and C# code samples welcome! Thanks. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-13 : 07:13:21
|
| We store one-procedure-per-file and then we concatenate them all together into one file to "deploy"Dunno if that's any help though?Kristen |
 |
|
|
|
|
|
Creating procedures from external files