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 |
|
lotand
Starting Member
8 Posts |
 Posted - 2007-07-13 : 16:58:55
|
| Hi,Do someone know if there is a SP_ or XP_ function for help me create a script of create table? I can do it "on-line" by right click a table in Enterprise-Manager (all properties;generate sql-script), but I want to "call a command" to do this.Very glad if someone know!//Lotta |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-13 : 17:54:41
|
| Not as I know of. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-07-13 : 19:45:57
|
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73608
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
lotand
Starting Member
8 Posts |
Posted - 2007-07-14 : 12:09:10
|
| Thanks! This was exact what I need! |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-07-14 : 14:29:06
|
I would stay away from DMO - it's deprecated in 2005, and probably won't ship with 2008.Here's an open source console app using SMO that you can use to automate generating scripts: http://www.codeplex.com/scriptdb
elsasoft.org |
|
|
|
lotand
Starting Member
8 Posts |
Posted - 2007-07-15 : 12:00:26
|
| Thanks! Not good to be dependent./Lotta |
|
|
|
|
|
|
Generate SQL-Scripts