Hi All,

Thank you very much for your response...

However, I still can't figure how to solve this issue...

May I know, how to clear/fix the Locks/objc thing.. I mean, it is not...

Thanks so Much

it works

EM was closed when I run that query..

however, when I check it using EM, the datbase is locked, by its user database.. the status is sleeping... awaiting command..

and when I try...

It does not work

I got this message:

"Server: Msg 5064, Level 16, State 1, Line 1

Changes to the state or options of database 'mydb'...

oh, SQL profiler, I tought you are talking about another profiler tools ( 3rd party software ). 

Thank you

It Works

Thanks for the advise, guys

Best Regards,

Andrew J.

Hi,

Thanks for the advise. btw, where can I find this tools : profiler ?

Thanks Again

Regards

I got 'mydatabaseuser' as the login name

so, the username is: 'dbo' and the login name for dbo is 'mydatabaseuser'

Hi

I found the solution

After completed restoring the database from .bak.

just detach that DB, the attach it...

Hi,

I think It is possible. when we try to restore database from .mdf .ldf, we can choose the default login for the database right? so, after the database created, it will...