Re: restrict access

Hi

To change this use

ALTER DATABASE SET MULTI_USER

If this is in single user then it could be because a maintenance task that
runs DBCC CHECKTABLE or DBCC CHECKDB and at some point it has not completed.
Make sure that you have notifications for your jobs.

John


"Sankalpa" <Sankalpa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7E32AE24-5B0C-41F0-BE27-CF69144A4AFD@xxxxxxxxxxxxxxxx
>I can see different databases.. If i right click on it and go to properties
> and then options i can see restrict access being checked.
>
> "Narayana Vyas Kondreddi" wrote:
>
>> Can you please provide more info on where this option is?
>>
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
>>
>>
>> "Sankalpa" <Sankalpa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:E020DFDE-8149-4738-B428-9D1B0B307459@xxxxxxxxxxxxxxxx
>> I am using sql server and i am getting restriction access option checked.
>> I
>> dont want this option to be selected and it happens randomly . Can
>> someone
>> help me what the deal is?
>>
>>
>>


.