I would wish to keep track of every users that logs into our database.

The reason why I'm doing this Is because we would wish to prevent the users, that we've granted access into our dataset, from sharing their credentials to other users without our permission. We are not always in front of our servers to monitor the users that are logged in so we wished to do this automatically every time a user session starts.

I know the statements to be used to get the username, computer name, etc. But I dont know how to automate this task. Manipulation of data in our server is purely via management studio so we are limited to what exists in SQL Server.

Is this possible? How?

There are many choices for recording this kind of information, all with their own advantages and disadvantages.

The quick and easy answer is to setup a SQL Profiler trace.

-PatP

thanks, the profiler can get me the information that i need but i need this to run automatically. i can run a job to create a trace automatically on startup but the script only allows to output the trace into a file. what I want is for it to be in a table.

what other ways can you suggest?

Create a trace using the SQL Profiler GUI, and send its output to a table. Run the trace and check the output to ensure that it is what you want. Save the trace on the SQL Server, and set it to start with the SQL Server.

-PatP

Sorry, im not really sure how to do this part? I've tried saving its script trace definition, but when I open the script trace def, it only allows me to save the output into a file.