Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sasan_vm
Yak Posting Veteran
51 Posts |
 Posted - 2010-02-19 : 16:26:15
|
| Hello,I create a table for any year in db and on new year i want set old year table to readonly , infact user cant modify data (insert, update, delete)How can do it ?Kind Regards,sasan. |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2010-02-19 : 21:18:46
|
| Create a new file group and mark it read only. Move the old year table to that file group.Mike"oh, that monkey is going to pay" |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-22 : 13:04:24
|
| or put a trigger on it |
|
|
|
|
|
|
Set Table ReadOnly