Many of us wants to know the underlying database of workspace connected. Use IDatabaseConnectionInfo2: when you want to know the type of DBMS the workspace is connected to. For example, when connected to a SQLServer database ConnectionDBMS will return the enumeration value corresponding to a SQLServer database. GeodatabaseServerClass Property of this interface lists Server class types. i.e Personal /Workgroup/Enterprise ArcSDE server.
Finding :Workspace- Connected Database