[dba-SQLServer] Can I share a connection object

Hi John:

Are we talking about sharing via a web based link?

Jim



-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Saturday, October 16, 2010 8:54 PM
To: Sqlserver-Dba
Subject: [dba-SQLServer] Can I share a connection object

I am doing a ton of stuff to a database in SQL Server, pulling all the
records in a table into a 
datatable, building out update SQL statements and using a command object to
update those records, 
building out insert sql statements and appending records into another table
etc.

My question is can I share the connection object between everything that
needs to have one?  I am 
going to be doing dozens of update and insert operations / second and if I
could just grab and share 
a connection it seems logical to do so.

-- 
John W. Colby
www.ColbyConsulting.com
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com