setting the query time out....

[Manuel]

i am using sqlserver 2000, and i was wondering how do i go about
setting the query time out. is there a way to configure the query
timeout for a specific user id?

[Simon Hayes]

Re: setting the query time out....

casianspice@yah oo.com (Manuel) wrote in message news:<a252b7a0. 0402261749.794c 0579@posting.go ogle.com>...[color=blue]
> i am using sqlserver 2000, and i was wondering how do i go about
> setting the query time out. is there a way to configure the query
> timeout for a specific user id?[/color]

That depends on how you are connecting to MSSQL. In Query Analyzer,
for example, there is an option on the Tools-Connections menu.
Otherwise, you need to set the timeout in your application code, and
how to do that depends on the specific library (ADO, ODBC, JDBC etc.)

Simon