sql server new users: Hi

Each month I back up the structure of our databases by right-clicking
on each database and select Generate SQL Script...

[quoted text, click to view]
tab I select script database, along with script indexes and script
primary keys.

As we have several databases this can take some time. Is there away to
automate this using a DTS?


Thanks
Matt

Google scptxfr; it's a command line utility that will script out a SQL
database. Combine that with VBScript in a DTS package, and you should
be good to go.

HTH,
Stu

Thanks for your reply.

Where do I get hold of scptxfr?

Thanks
Matt

It gets installed as part of the Upgrade Tools when you install SQL
Server; if you have the disks, I would simply do an install with the
Upgrade Tools, and then you can copy the scptxfr executable to any
machine you wish.