I feel he is asking for:

1. Use stored procedures.

2. Use DB Maintenance Plan wizard..

I hope I understood it correctly.

Regards,
San

--- John Thomas <[Email Address Removed] wrote:
> I am not quite sure I understood what you are
> asking. I use Enterprise
> Manager for most of the scripting tasks.
>
> John
>
> -----Original Message-----
> From: sandeep shinagare
> [mailto:[Email Address Removed]
> Sent: Friday, July 25, 2003 1:56 AM
> To: LazyDBA.com Discussion
> Subject: recommendation for SQL2K server scripts..
>
> Hi,
> What is the preferred method of scripting (say
> backup
> & recovery process) for the MS SQL Server?
> Is VB Scripting considered the most suitable?
> Any inputs/ prod-cons appreciated.
> Cheers,
> Sandeep
>
>
________________________________________________________________________
> Want to chat instantly with your online friends?
> Get the FREE Yahoo!
> Messenger http://uk.messenger.yahoo.com/
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
MS Sql Server LazyDBA home page