>thanx bob.
>is there any way to view all kind of logs without using third party tool, I mean sql server itself must be having if not a GUI.
>can u provide me any URL which guide me through how the logs are kept and viewed in sql server.

You could read the log yourself, and I am sure it is documented somewhere.

You may also want to look at another tool that lets you add audit data to your datbase. It is called SQL Audit from Red Matrix technologies. A site license is $495. Check it out at http://www.redmatrix.com/default.asp?section=sqlaudit .

BOb