Somehow, when I restored ePO database by SSMSE 2005, following error comes.
System.Data.SqlClient.SqlError: RESTORE cannot process database 'ePO4_YK2K3' because it is in use by this session.
It is recommended that the master database be used when performing this operation. (Microsoft.SqlServer.Express.Smo)
"ePO4_YK2K3" is my database name.
The error comes only when I logon by windows Administrator user.
Even if I enable "Overwrite the existing database" option, the error comes still.
However, if I logon by "sa" user with SQL authentication, it is possible to restore the database without error... somoehow...
Do anyone know why the error comes onky when I logon by windows Administrator?
Is it a specification of SSMSE?