Thank you so much! That's what I was looking for!

Albert Frazer
Home Decor Products, Inc
www.hdpi.com
732-593-3637 (office)
732-570-4465 (cell)

-----Original Message-----
From: Brendt Hess
[mailto:mssqldba-ezmlmshield-x16360556.[Email address protected]
Sent: Wednesday, January 31, 2007 12:17 PM
To: LazyDBA Discussion
Subject: RE: script database

I use a vbScript routine at the command prompt to script out all of my
tables, derived from one of several such scripts (for all objects,
including
jobs &c) I came across on the web. All of these scripts use DMO.

You will probably be able to use this script as a base for what you
need:

http://www.codeproject.com/useritems/0g_SqlExtract.asp

==+==+==+==+==+==+==+==+==+==+==+==+
Brendt W. Hess
Database Administrator, Motosport, Inc.
brendt.[Email address protected]
==+==+==+==+==+==+==+==+==+==+==+==+

-----Original Message-----
From: Albert Frazer
[mailto:mssqldba-ezmlmshield-x13361137.[Email address protected]
Sent: Wednesday, January 31, 2007 7:41 AM
To: LazyDBA Discussion
Subject: script database

I'm not sure if somebody already asked for it, but is there a way to
script the entire database (objects, roles, logins, users) not using EM
in SQL Server 2000?



Thanks,



Albert Frazer

Home Decor Products, Inc

www.hdpi.com <http://www.hdpi.com>

732-593-3637 (office)

732-570-4465 (cell)





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html






---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page