Hi,
I seems to having this issue that a database is changing itself on the
access rights to a 'restrict access for single user mode'.
Basically I did not do anything to change that mode, but may I know if there
is any way that I can prevent it changing to the single user mode? Currently
I'm not having any access restriction setup in the 'Access' under property
page of the database.
FYI, I'm using MSSQL 2K - sp4.
Please advice.It could be a maintenance plan. If you use them, look at the
integrity checks and make sure to uncheck the "attempt to
repair any minor problem" option.
-Sue
On Thu, 23 Feb 2006 17:29:02 -0800, "seal_cet"
<seal_cet@.discussions.microsoft.com> wrote:
>Hi,
>I seems to having this issue that a database is changing itself on the
>access rights to a 'restrict access for single user mode'.
>Basically I did not do anything to change that mode, but may I know if ther
e
>is any way that I can prevent it changing to the single user mode? Currentl
y
>I'm not having any access restriction setup in the 'Access' under property
>page of the database.
>FYI, I'm using MSSQL 2K - sp4.
>Please advice.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment