Hi
The osql/isql command prompt utilities are documented in Books Online and at
http://msdn.microsoft.com/library/de..._osql_1wxl.asp
Use the -S option to specify the instance that is going to be used and
repeat it for each instance.
Alternatively you may want to write a program that uses DMO.
John
"Gary" <gary.todd@kbci.com> wrote in message
news:932907e8.0408270730.6ab6e42f@posting.google.c om...[color=blue]
> I want to run and 'Alter Database' statement from within a batch file.
> The batch file is to be run from an external automation program,
> (don't ask why)..
> I know the syntax for the alter db statement but not sure how to do it
> in a batch file and also If I have 2 instances how do I run it against
> each instance.
> All being done on Windows 2000 with Sql 2000.
> Any ideas will be a help.[/color]
