>I'm trying to roll back all pending changes to SQL, unfortunately I can't find a command that gives all valid connections to SQL.

Fabian,

How many connections do you have going at one time in your application? I would think that all you need is one connection with which to do your data access, no?

Are you using a DBC-based connection or using SQLCONNECT/SQLSTRINGCONNECT to obtain a connection handle?

Laterness,
Jon