Changin initial catalog inside transaction for sql server

[Choi, W. Byung]

Hi.   This dosen’t change database. But if I call “DAOFactory.SetDatabase” Outside of transaction database (intial catalog) is changed properly. Both database is in same server (sql server).   try             {                 DAOFactory.BeginTransaction();                   DAOFactory.SetDatabase(DAOFactory.GetPublicDBName());                 Load(id);                   Lock();                   DAOFactory.SetDatabase(DAOFactory.GetTempDBName());                 Commit();                   DAOFactory.CommitTransaction();             }             catch(Exception ex)             {                 DAOFactory.RollBackTransaction();                 System.Windows.Forms.MessageBox.Show(ex.Message);              }     Byung