"Mtcc" <m> wrote in message news:3fbfb273$1@news.012.net.il...
> what you suggest me for this situation:
>
> I maintenance flat tables with sums fields etc. that improve performance
for
> some report.
> I don't want to do that on trigger. instead i want to run another
> thread with low priority to do it.
>
>
> This process is update only the flat table. There for I don't think that
> make lock.
>
>
> I know that have a way to define job that start running when processor
idle,
> but I want to
>
> Run it all on Low-Priority.
>
>
> Have a way to run process on sql server 2000 (in any way) that run on Low
> priority?
>
> (I understand that if I send the request from low priority thread client
> side is not help me)
>
>
>
>
>
>
>

"Roji. P. Thomas" <someone@somewherel.com> wrote in message
news:%23FC6HGZsDHA.3436@tk2msftngp13.phx.gbl...
> AS far as I know, you cant.
>
> But then I know too little :)
>
>
> --
> Roji. P. Thomas
> SQL Server Programmer ;)
> ________________________
> "Mtcc" <m> wrote in message news:3fbfb273$1@news.012.net.il...
> > what you suggest me for this situation:
> >
> > I maintenance flat tables with sums fields etc. that improve performance
> for
> > some report.
> > I don't want to do that on trigger. instead i want to run another
> > thread with low priority to do it.
> >
> >
> > This process is update only the flat table. There for I don't think that
> > make lock.
> >
> >
> > I know that have a way to define job that start running when processor
> idle,
> > but I want to
> >
> > Run it all on Low-Priority.
> >
> >
> > Have a way to run process on sql server 2000 (in any way) that run on
Low
> > priority?
> >
> > (I understand that if I send the request from low priority thread client
> > side is not help me)
> >
> >
> >
> >
> >
> >
> >
>
>

> I maintenance flat tables with sums fields etc. that improve performance for
> some report.
> I don't want to do that on trigger. instead i want to run another
> thread with low priority to do it.