>Is it a better practice to establish a remote connection why an app starts and leave the connection static until the app ends?
>
>Or
>
>Make connections on the fly and do the various SPT statements need their own connection handle?

I'd think the latter would be almost always preferred. However, what the backend is could be a critical. If it's SQL Server you'd need a license for the maximum number of simultaneous connections (I *think* I have the correct).