Home > Archive > MS SQL Server > February 2006 > Remaining connection









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Remaining connection
FJC

2006-02-10, 3:23 am

We are running SQL2k and one of the users is accessesing one of the databases
through the front-end applications, the problem is that the connection is
never closed after the user closes the front-end application and the other
users' do.
Uri Dimant

2006-02-10, 3:23 am

FJC
SET Connection= NOTHING




"FJC" <FJC@discussions.microsoft.com> wrote in message
news:77863053-5A97-48BF-B5B5- 12C930E50D91@microso
ft.com...
> We are running SQL2k and one of the users is accessesing one of the
> databases
> through the front-end applications, the problem is that the connection is
> never closed after the user closes the front-end application and the other
> users' do.



FJC

2006-02-12, 8:23 pm

Thanks Uri

"Uri Dimant" wrote:

> FJC
> SET Connection= NOTHING
>
>
>
>
> "FJC" <FJC@discussions.microsoft.com> wrote in message
> news:77863053-5A97-48BF-B5B5- 12C930E50D91@microso
ft.com...
>
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com