Howdy all. Im not a guru VBS guy and Id like to use it to
script out SQL2K db objects. Say I just wanted to script
out the views and nothing more. Can VBS do this? Can
someone get me pointed in the right direction?

TIA, Chris

If you want to do it in VBS and not using EM then you can use the SQLDMO
library.

Each Database object has a Views Collection. The view object has a Script
method



--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"chris" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I appreciate your quick response. Views were an example.
Can I use it SQLDMO for other objects as well?

Oh yes

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"chris" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Yup. The following link has a diagram of the SQL Server DMO
Object Tree - it shows what objects are exposed in SQL-DMO:
http://msdn.microsoft.com/library/en...con03_39yd.asp
If you go to databases, you can see what db objects are
exposed. In terms of what supports the script method, there
are different script methods depending on what you are doing
or wanting to accomplish. You can find the info for the
methods in the SQL-DMO reference in books online or at:
http://msdn.microsoft.com/library/en...ef_ob_3tlx.asp

-Sue

On Mon, 3 Nov 2003 14:38:08 -0800, "chris"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Here's a examples of doing it from t-sql.
Should be easy to convert to vbs

http://www.nigelrivett.net/DMOScriptAllDatabases.html
http://www.nigelrivett.net/DMOScripting.html

Nigel Rivett
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!