Hi Lowell,

Yes, you are right every user has db_ddladmin role so this is the issue.

Thank you very much for your help.

Cheers,

Marcin

Hi All,

Thank you very much for you answers

The conclusion is as someone write in this forum 'that there is no guarantee that in between the execution of the alter database...

Hi,

But object explorer uses different connection so it shouldn't take this one session.

Cheers,

Martin

Hi John

I know that it is not necessary but i need that for further processing

I've got system 7/24 and need to move some databases to new storage.

So I

1)Restore copy of...

Hi Gail,

Thank you very much for answer,

but I've tried to reproduce your scenario

1)From one session

USE [master]

GO

ALTER DATABASE [test] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

2)From second session

use [test]

Msg 924, Level...

Hi,

No, single user mode will not work.

Altering database in this way require setting int off and online.

Cheers,

Marcin

Hi,

The easiest way to move logshipped database

1)Stop logshipping

use master

alter database [xxx] set offline

alter database [xx] modify file (name=xxx_log, FILENAME='some_path\xxx_log.ldf')

2)Physically move log files to path 'some_path'

3)alter database [xxx] set online

6)Resume...