Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Issue regarding SQL Server connection close

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-10 : 07:47:34
Trupti writes "Hi,
For our project we have used the Visual Studio .NET 2003 & in the code we close the connection every time when it's not needed & at the same time we dispose it. And not using any connection pooling, But actually it does not get closed.We can still see the open connection in the SQL Profiler.
Is there any setting in the SQL Server to do this?
I mean whenever the connection is disposed, it should get removed.


Waiting for the reply...

Thanks"
   

- Advertisement -