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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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...
With all respect to leew, believe I contributed to answer precisely to the asked question; I do believe i deserve some points for that...
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