What is SQL Server Default Trace? The default trace is a system-defined trace which is used to record a large number of events. How to enable/disable it? Script to Enable and Disable the Default Trace in SQL Server Where is trace file located? [crayon-6a24df00ec116072778572/] Which type of events are captured by default trace? Database Events: […]

I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM. I'm working as a Database Architect, Database Optimizer, Database Administrator, Database Developer. Providing the best articles and solutions for different problems in the best manner through my blogs is my passion. I have more than six years of experience with various RDBMS products like MSSQL Server, PostgreSQL, MySQL, Greenplum and currently learning and doing research on BIGData and NoSQL technology. -- Hyderabad, India.