plz,just new to ms sql server 2000 cos i want to work on a project for my departmental library. there will be lots of user(students) connecting to the database thru clients which on reside on a server.am thinking of not using windows authentication mechanism. users will have different levels of access to the database. where will i create information and passwords of these users. will i create and maintain a table for this Or i use the user option under the database name?
oyad