Simple explanation you can find in BOL:  "Database Owner (dbo)"

Hope this helps

Try to use one of the fixed server role sysadmin or securityadmin(in order only to create a new login) account.

Yes it's working. Thanks. It also works with IP and port number through the server alias

I have a suspicion that there is a named instances issue...

Yes, Siva, I've allready checked these IP addresses. It doesn't work. Neither physical nor virtual. On sql server log it's said that one node listen to xx.xx.xx.x1 :1433 , other...

Well you learn learn and at last you see that there is no end... Thank you for suggestions. Earlier I didn't heard anything about that msdb role

Cheers

I can't remember exactly it's name, but I can post it after couple hours later when I'll be at home. It was a year ago, so I don't remember. It's...

In theory it could be restored I think. There are some tools on NET which could recover your deleted files. I remember when I'd run such utility once, it recovered many files...

Well, no. Such SQL Server  security hierarchy. There is one simple way to execute sa job, but then there must be a stored procedure, which runs a job, and...

On my oppinion there is no necessity to do that especialy if you DB are quite large

Cheers

Have you any error output(s) which you can share with us?

I'm glad to help you. I think that you didn't understand me what I wanted to say you about other two statement...

If you will execute

ALTER DATABASE test1

set SINGLE_USER

WITH ROLLBACK...

No. This statement  ALTER DATABASE TEST1 SET SINGLE_USER  you can execute when there are no coonected users. You must kill them manually.

Look at these the 2 statements which I wrote...

I've aslo found couple usefull options regarding to single_user mode:

ALTER DATABASE TEST1 

set SINGLE_USER

WITH ROLLBACK IMMEDIATE

--and the second

ALTER DATABASE TEST1 

set SINGLE_USER

WITH ROLLBACK AFTER 20 SECONDS

The first one...

Make sure that you will execute the following commands like checkdb in the same QA window or you'll be not allowed to do that (single_user)

Cheers