MSSQL Database Switching

[eluser]whobutsb[/eluser]
I need to switch because I need to grab data from different databases. I find sometimes the issue is if i'm looking on the same server in different databases the, the 'used' database in MSSQL is the wrong one, and CI will be running a query in the wrong database.

Do you have an example of the library that you are using to the load/switch the databases? I would be interested in seeing what it does.

Thanks,
Steve