You can expose pretty much any parameter you want regardless of position using a pattern-based string splitter like this:

WITH SampleData (ID, ConnectionString) AS

(

SELECT 1, 'server=SVR1;database=DB1;uid=user1;pwd=pass1;enlist=true'

UNION ALL SELECT 2, 'database=DB1;server=SVR1;uid=user1;pwd=pass1;enlist=true'

UNION ALL SELECT 3, 'server=SVR1;uid=user1;pwd=pass1;database=DB1;enlist=true'

),

Params AS

(

SELECT *

FROM SampleData

CROSS APPLY PatternSplitCM(ConnectionString, '[;=]')

WHERE [Matched]=0

)

SELECT ID, dbname=Item

FROM Params a

WHERE ItemNumber =

(

SELECT 2+ItemNumber

FROM Params b

WHERE a.ID = b.ID AND b.Item = 'database'

);

PatternSplitCM is a utility function that can be found in the 4th article in my signature links.