hai,please tell me how to lock database in sql server.In our company we are maintaing an e-commerce site.in that every one have rights to access database.if any one made changes to database those are reflecting when we export data.let me know how can i give permisions to other colleagues so that they can't do any modifications.Thanks in advance.