Linked Server connections

I have a server in my office which is configured as a linked server on
another one.
How can I configure the connections between them to be killed after a period
of non-useness. As the connections are not killed after some time the limit
of connections in my server is exceeded. The connections appear as dormant
(their status).
Cintia,
Your connections are exceeded? Sounds like you are using a desktop sql
server, which is not intended for production use. (If this is correct, then
you should upgrade to Developer Edition or Standard Edition depending on
what you are doing.)
The MSDN makes this comment about 'dormant': After the connection has been
reset, the SPID indicates that it is in a "dormant" state in the
sysprocesses system table. If you do not use the connection for a period of
time a background process closes the connection. Such a SPID should not be
holding on to any locks or resources that would affect other users.
So, the process will close out eventually. It is just taking too long for
your purpose. You can - sometimes - kill these, but that is not a
recommended procedure since you could have one task killing a SPID at the
same moment that another task is trying to use it.
RLF
"Cintia Goncalves" <Cintia Goncalves@.discussions.microsoft.com> wrote in
message news:F230DFB6-C64D-4F9B-A074-A58C1F5047D6@.microsoft.com...
> I have a server in my office which is configured as a linked server on
> another one.
> How can I configure the connections between them to be killed after a
period
> of non-useness. As the connections are not killed after some time the
limit
> of connections in my server is exceeded. The connections appear as dormant
> (their status).