Hello,
This is a workaround. Can you use T-SQL's: SET ROWCOUNT ?
This limits the number of rows returned by a query.
-- John
""Brinkman, Theodore"" <[EMAIL PROTECTED]> wrote in
message FE8510398BFE854F9653B5C32DBB652FD4F39E@oh_daytn_xch01">news:FE8510398BFE854F9653B5C32DBB652FD4F39E@oh_daytn_xch01...
> I'm working on an application for work where users will be querying the
> database to get information back about processed documents. I'm trying to
> set up a way for a user to cancel a query which is taking too long. I'm
> using MS SQL Server 2000. The interface for the cancel is easy enough, a
> form containing a button that says 'cancel' and a value or set of values
> identifying the query being run.
>
> I've found 'KILL <SPID>', but the problem is that all the connections to
the
> database are done through the web-server so they get the same SPID, which
> means that EVERY query being run by EVERY user gets killed. (Obviously
not
> an acceptable solution.) Does anybody out there know of a way to
> specifically kill a single query/stored procedure? We're willing to track
> as many values as necessary to do it.
>
> Thanks.
>
> - Theo
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
