Hi all

I am new to sqlserver and is confused with many things in sqlserver
i have few doubhts . Please help me to solve this

1) I want to alter the password of the user sa
2) i want to create some new users and give them persmission
such that they can only insert, update , and select .No create , alter and drop

3) how to do auditing in sqlserver


Please help me in solving this . In my database many people are playing and i am trying to restrict it.This is urgent .


regards,
shibu
MS Sql Server LazyDBA home page