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 |
|
interclubs
Yak Posting Veteran
63 Posts |
 Posted - 2003-02-19 : 11:05:33
|
| I am continually transferring over commonly used tables (such as country codes) in DTS. I would love to write a stored proc that I could pass a table name, and it would then return the code to create the table and all the insert statements to insert the data. Does anyone one have anything vaguely like this that I could modify? It's a little beyond my experience level.Thanks,Scott Phillips |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-02-19 : 11:19:31
|
| DTS Does this for you already...I guess I'm missing the point? |
 |
|
|
interclubs
Yak Posting Veteran
63 Posts |
Posted - 2003-02-19 : 11:29:39
|
| Yeah, would just save some time if I didn't have to go into DTS everytime, if I just had some scripts I could run through the QA. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
|
|
|
|
|
Curious Idea, anyone have a stored proc?