Read only

How can I make a table(not the entire database)read only?GRANT SELECT ON myTable TO <User/Role>

DENY INSERT, UPDATE, DELETE ON myTable TO <User/Role>

Look these up in BOLsql

RE: Creating A Duplicate Database Without Enterprise Manager

Hi There,

I was wondering if there was a simple way of create a duplicate of an entire database.

I often need to create a second copy of a database for development purposes. I have lost the use of Enterprise Manager which I can no longer simply script the database and then use dts to move the data across.

Is there a way of doing this in T-SQL?

Thanks

SteveTake a full backup and restore as a different name ... that should do it .. i think ... rather than going about it the other way round.|||You lost the use of Enterprise Manager?

HUH?|||I think they're an amputee|||Perhaps it was destroyed by a Klingon Manager?|||Or a Romulan cloaking device has been attached, so it's really there, he just can't see it ;-)|||Could have been an Organian illusion all along...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55463