From: "Robert Comer" 

> You do realize you could simplify your life by just putting the inp part
in
> the SQL scheduler queue.

Yes I do, I have even more things in there -- why I do it in this case is
so I can capture the output and examine it later.

- Bob Comer


"Geo."  wrote in message news:3e235019{at}w3.nls.net...
> "Robert Comer"  wrote in message
> news:3e2305a2{at}w3.nls.net...
> > No problem!
> >
> > Just as an example:
> >
> > Here's a .BAT file:
> >
> > isql /d ProdInfo /n /Uxxxxxx /Pxxxxxx >c:\administration\checkident.txt
> >  > exit
>
>
> You do realize you could simplify your life by just putting the inp part
in
> the SQL scheduler queue. if you have a bunch of inp files you run in
> sequence, just put them in there separated by "go" on a line
by itself,
now
> one will finish before the other starts. Example below.
>
> Geo.
>
> DBCC CheckDB
> GO
>
> DBCC NewAlloc
> GO
>
> DECLARE {at}query VARCHAR(100)
> SELECT {at}query = "DBCC UpdateUsage("+ DB_NAME() + ")"
> EXEC ({at}query)
> GO
>
> DBCC CheckIdent(Actions)
> GO
>
> DBCC CheckIdent(Charges)
> GO
>
> DBCC CheckIdent(ChargeTypes)
> GO
>
>

--- BBBS/NT v4.01 Flag-4