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 |
|
sherrys
Starting Member
37 Posts |
 Posted - 2003-12-08 : 14:04:41
|
| When I script more than one object to multiple files, enterprise manager prefixes them with dbo. and also suffixes them with things like .TAB, or, .TRG, or .VIW. Can I turn this off? I want them to come out the same way they do when you choose to send your output to just one file. No owner and suffix = .sql.Thanks for your help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-08 : 14:07:22
|
| No you can not turn it off. Just write some VBScript to rename them. Script would be pretty simple, remove first 4 characters, change last 3 to sql. I actually like the extensions that EM uses when scripting them out to multiple files. It allows for easy grouping.Tara |
 |
|
|
sherrys
Starting Member
37 Posts |
Posted - 2003-12-08 : 14:17:31
|
| Thanks for the info. I am dusting off my vbscript book now. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-12-08 : 15:10:37
|
| You can use dmo to create your own filesseehttp://www.nigelrivett.net/DMOScripting.htmlhttp://www.nigelrivett.net/DMOScriptAllDatabases.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
scripting objects to multiple files