No, I think the system tables in the database you're in are read-only also.
The ones in master will be read-write, of course.
Mark.
www.allisonmitchell.com
-----Original Message-----
From: Sexton, Kevin [mailto:kevin.[Email Address Removed] 27 February 2002 18:24
To: [Email Address Removed] read only
If I make a database read-only will the system tables be updated still.
I would think the would be exempt from the read-only permission.???
Kevin J. Sexton
Sr. Database Administrator
AdvanceMed Corporation
11710 Plaza America Drive
Reston, VA 20190-6017
http://www.eadvancemed.com
---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system. If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.
For further information about Clifford Chance please see our website at http://www.cliffordchance.com or refer to any Clifford Chance office.
MS Sql Server LazyDBA home page