Link to home
Start Free TrialLog in
Avatar of ibmas4002
ibmas4002

asked on

SQL server Logs

Hi All

I Need to know all the SQL logs including auditing the sql events, I want to check the SQL Logs so I can track any problmes in SQL, Also i want to know what is the maximum Databasesize in Ms SQL 2000.


Thanks
ASKER CERTIFIED SOLUTION
Avatar of Lee W, MVP
Lee W, MVP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of nmcdermaid
nmcdermaid

There's the standard SQL logs, most easily found in Enterprise manager.

Then you can also run a trace in SQL Profiler that will give you more event information than you could analyze in three lifetimes.

Fire up SQL Profiler and have a look
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi LearnedOne,

With all respect to leew, believe I contributed to answer precisely to the asked question;  I do believe i deserve some points for that...