.comment-link {margin-left:.6em;}

Sunday, April 23, 2006

 

Connection Pooling


This is a very interesting funny notice :
Connection Strings must be IDENTICAL . so what is new ?

Conn1 : "Server=SQL01;Database=AdventureWorks;Integrated
Security=SSPI;Pooling=true"
Conn2 : "Server=SQL01;Database=AdventureWorks;Integrated Security=SSPI
;Pooling=true"

These are not identical since the second connection string has a SPACE after
the word SSPI, so they generate two different pools.you can examine that by
SQL Profiler .
It is very interesting ha .


Comments: Post a Comment

Links to this post:

Create a Link



<< Home

This page is powered by Blogger. Isn't yours?