Restricting sql user connection..

hi,

i have question restricting sql user connection after amount of time. (sql 2000)

in otherwords can kill connections made application aftercertain amount of time. (say 50 seconds.)

i saw options sql query analyzer tools->options -> connections

1. login timeout
2. network package size
3. query timeout
4. lock timeout

i guess setting of meet requirement.

if 1 used these kind of requirement please post here.

or

can use 'remote query timeout option' sp_configure.

thanks in advance
mka

connections 'should' controlled application. applications, design use connection pooling, purposefully leaving 1 or more connections 'open' in order increase response time application.

 

with .net applications, may wish explore properties , methods of connection, , connection pool objects.

 

i, personally, wouldn't bother attempting control connections within server.

SQL Server  >  SQL Server Tools