Backup SQL Objects

[xloop]

How would i go about automatactially creating SQL scrips for all the tables, views and stored procedures in a particular database?

Need to do this every night (automatically)

Any help much appreciated

 

[dbomrrsm]

In enterprise Manager:

Expand a server group, and then expand a server.


Expand Databases, right-click the database to script, point to All Tasks, and then click Generate SQL Scripts.


On the General tab, select the database objects to script. By default, all objects in the database are scripted.

Script what you like !!!

DBomrrsm

 

[xloop]

The key word here is "automatically"

We need to run it every night without having to go into enterprise manager.

Any ideas?

 

[dbomrrsm]

Try this link to a SP created by NigelRivett

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

Probably a good start.

DBomrrsm

 

[xloop]

Magic, thanks