Re: READ ONLY databases

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 09/17/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Mon, 16 Sep 2002 18:59:57 -0600

If by read only tables you mean that you right click on the
table and select Open and are unable to modify data, this is
usually due to not having a primary key or unique index on
the table.

-Sue

On Mon, 16 Sep 2002 10:47:37 -0700, "R M Kumin"
<kuminr@battelle.org> wrote:

>I am having an odd problem with SQL Server/Query
>Analyzer. I can create databases / tables but the tables
>end up as "READ ONLY" in query analyzer. Database is
>created read_only = false; all permissions are open (my
>login is part of the sa and administrator groups) all
>directory permissions, etc. are open. There are no
>(obvious) problems with permissions, and all properties
>inspected seem to be OK.
>System is Windows 2K; SQL Server 2K. We do have Active
>Directory on our file systems/servers now and the
>suspicion is that the login name permissions may be
>causing this issue (though we cannot see any conflicts.)
>
>Any ideas?