During the running of my application it connects to sql launches some code and then I close the connection, but as long as my application is running, SQL still has a process for it which is sleeping but id like to clear this out. Is there a way to do this without closing the application.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
C# & SQL Process's
- Thread starter stathread
- Start date
Why do you need to clear it out? The next time your app connects with the identical connect string, SQL Server will reuse this internal connection structure, thus saving time.
Chip H.
____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first
Chip H.
____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first
- Status
Similar threads
- Locked
- Question