Dim StoredProc As New ADODB.Command
Set StoredProc.ActiveConnection = objConnect
StoredProc.CommandText = spCommand
StoredProc.Execute

1 Question: How to release the StoredProc memory or instance?
2 Question: How to disconnect the connection after objContext.setcomplete/
setabort

-------------------------------------------------------------

'-- Close Connection for Pooling --
objConnect.Close
Set objConnect = Nothing

'-- Inform MTS to reuse the object --
mobjContext.SetComplete

3. Question: "Set objConnect = Nothing" first or "SetComplete " first? How
to let MTS to release or control my instance?
All of the codes can run, but it's standard?

-------------------------------------------------------------

BEGIN DISTRIBUTED TRANSACTION vs BEGIN TRANSACTION
----------------------------- -----------------
4. Question: What different between the first and second one.
After I tried to use in StoredProc, both also can run under DTC Provided
service.