p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

sql_server thread: DDL script


Message #1 by "Xu Gary" <Gary.Xu@p...> on Fri, 26 Jan 2001 18:40:40 -0800
To provide the flexibility you are talking about you might need to build a
SQL-DMO application. It allows you to build and perform all functions
performed by SQL Enterprise Manager. Look in BOL(SQL Books on Line)to see
example of how to program the stuff.

-----Original Message-----
From: Xu Gary [mailto:Gary.Xu@p...]
Sent: Monday, January 29, 2001 12:15 PM
To: SQL Server
Subject: [sql_server] Re: DDL script


Thanks. What kind of task? T-SQL? How do I write the T-SQL? 

 


-----Original Message-----
From: John Pirkey [mailto:mailjohnny101@y...]
Sent: Saturday, January 27, 2001 3:19 AM
To: SQL Server
Subject: [sql_server] Re: DDL script


you could probably set up a scheduled task that could generate that for you.
The
task (or Job in SQL 7 and higher) would probably need admin rights to the
system for
this kind of action though.

good luck,

john

--- Xu Gary <Gary.Xu@p...> wrote:
> I am modifying a big DB. Backing up is too much. If there a way to have
SQL
> server generate DDL every few hours automatically? I want to have
something
> like auto save.

---------------------------- 
John Pirkey 
MCSD 
John@S... 
http://www.stlvbug.org


  Return to Index