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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-27 : 09:27:04
|
| Eric writes "I have a seperate database that keeps track of all my procs. It categorizes them, and lets me know which ones go to which clients, and which ones are only for development. The problem is I can not seem to find a good, inexpensive, and simple tool that can take a list, or a query and generate a script of those objects. Query Analyzer seems to have the best scripting I've seen. Better the Enterprise Manager for sure. Is there a way to get QA to script from the command line? Then I could write my own system." |
|
|
ttcrissy
Starting Member
8 Posts |
Posted - 2002-04-29 : 04:23:27
|
| Have a look at the "syscomments" system table. You may find some interesting sp code there.Best luck. |
 |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-04-29 : 05:47:16
|
| For ultimate flexibility, you should write an SQL DMO application in VB or VC to query your meta-data, and generate scripts only for the required objects.--HTH,VyasCheck out my SQL Server site @http://vyaskn.tripod.com |
|
|
|
|
|
|
Data driven scripting.