open table

12 May 2005 6:35 PM

Ilann

when I right ona table in the object browser in query analyzer it opens the
selected table,
in some tables I can edit the content in some, I can't,

do you have any idea?

Thanks

Ilann

12 May 2005 6:42 PM

Hari Prasad

Hi,

You may not have rights to edit those tables. Execute sp_helprotect
'null','tablename' and see if you have permissions for those tables.

Thanks
Hari
SQL Server MVP

Show quote

"Ilann" <il***@free.fr> wrote in message
news:O5dRcFyVFHA.2684@TK2MSFTNGP09.phx.gbl...
> when I right ona table in the object browser in query analyzer it opens
> the selected table,
> in some tables I can edit the content in some, I can't,
>
> do you have any idea?
>
> Thanks
> null,'tablename' Ilann
>
>

12 May 2005 6:50 PM

Ilann

I got this:

There are no matching rows on which to report.

Ilann
Show quote

"Hari Prasad" <hari_prasa***@hotmail.com> wrote in message
news:euLXhIyVFHA.1404@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> You may not have rights to edit those tables. Execute sp_helprotect
> 'null','tablename' and see if you have permissions for those tables.
>
> Thanks
> Hari
> SQL Server MVP
>
> "Ilann" <il***@free.fr> wrote in message
> news:O5dRcFyVFHA.2684@TK2MSFTNGP09.phx.gbl...
>> when I right ona table in the object browser in query analyzer it opens
>> the selected table,
>> in some tables I can edit the content in some, I can't,
>>
>> do you have any idea?
>>
>> Thanks
>> null,'tablename' Ilann
>>
>>
>
>
>

12 May 2005 7:29 PM

David Gugick

Ilann wrote:

> when I right ona table in the object browser in query analyzer it
> opens the selected table,
> in some tables I can edit the content in some, I can't,
>
> do you have any idea?
>
> Thanks
>
> Ilann

I've noticed that in past testing if a table had an indentity column, I
could edit it. Without one, I could not. That may be a bit of a
simplification. It could be related to a whether the table has a PK or
not or a unique index.

--
David Gugick
Imceda Software
www.imceda.com