read only mode

Question

hi is there a query that returns me the read-only status of a TABLE?!?!? the thing is that looks like only one table is on read only mode in my database

Answer 1

tables cant be read only; however, file groups can be read only.  You can use the query below to check the file group settings of the table.

SELECT
    t.NAME AS Table_Name,
    f.NAME AS FG_Name,
    is_default,
    is_read_only
FROM
    sys.indexes i
INNER JOIN sys.filegroups f
    ON i.data_space_id = f.data_space_id
INNER JOIN sys.tables t
    ON i.OBJECT_ID = t.OBJECT_ID
WHERE
    t.TYPE = 'U'
    AND t.is_ms_shipped = 0
    AND i.type IN (0,1) --0=heap,1=clustered index
    AND t.NAME = 'MyTableName'

---

http://jahaines.blogspot.com/

Answer 2

Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.indexes'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.filegroups'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.tables'.

Answer 3

What version of SQL are you using?

---

http://jahaines.blogspot.com/

Answer 4

You have to execute the above mentioned query in master