Menu

#1 Additional commandline arguments

open
nobody
None
5
2006-01-06
2006-01-06
Anonymous
No

Would be quite useful to have some dynamic arguments
available for the commandline.

A good example would be the date, especially if you
were doing a backup

-S {Data Source} -E -q "BACKUP DATABASE [{Database}]
TO DISK='\\SERVER\SQLDUMP\{today}_{Database}.BAK'"

Plus some "custom" atttributes per server
configuration.

Custom1=BackupPath

-S {Data Source} -E -q "BACKUP DATABASE [{Database}]
TO DISK='{BackupPath}\{today}_{Database}.BAK'"

That way you only need to define the variable once
per server, but can use it for multiple programs.

Discussion


Log in to post a comment.