> So does the driver just call that API on the DB and the procs are > created inside the DB? What causes the procs to go away later? (I > assume they're GC'd at some point otherwise you'd end up with millions > of them in the DB :)
In SQL Server, anything beginning with "sp_" are stored procedures built into SQL Server. So, the driver invokes those SPs to create and invoke a new temporary SP. Temporary objects (including these SPs) are tied to the connection that creates them, so they're destroyed when the connection is closed. Since most CF apps share the connection for all users of the application, there typically aren't really all that many in the cache. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336112 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm