I just did want to do a job, because I can use an interface with ASP later, but I will do a job using a timer event to disconnect the inactive user.

Thanks


>SQL Server does not provide this functionality natively. You'll have to create a job that looks for connections that have been idle for a while and KILL them.
>
>You can find a lot of the information that you're looking for in the sysprocesses table which is in the master database. Specifically, the table contains a column called last_batch. last_batch contains the date/time that the connection last executed a batch.
>
>The job will have to run under a login that is in either the sysadmin or processadmin fixed server roles. My suggestion is to create a login and put it in the processadmin role.
>
>BTW, is there a particular reason that you're looking to implement something like this?
>
>-Mike
>
>>Hello *.*
>>
>>Are there some property, function, SP, parameter (anything) who disconnect an user automaticaly?
>>
>>If my user is inactive for "n" time I want disconect this user.
>>
>>I dont want to do it from VFP, I´d like to do it from SQL SERVER.
>>
>>Does Someone can help me?
>>
>>Thanks in advance.