is there a way to make sybase limit what it looks for ? I know rowcount will
make it only return so many rows.. but that wont make it stop searching the
whole DB before it does it..

I have people running wide open queries that kill the system and they
will keep on doing it once and a while.. impossible to stop.. I wish I could..

so I tried rowcount, but thats no good.. it only limits what it spits out now how many it searches.. so is there a way to say after you found x rows, just stop ? or only look through 500k entries and return.. anything to make it
stop finding way more than it can handle before it tries to rowcount chop it ?

anyone ?