• You might also want to try:

    fn_trace_gettable

    as:

    SELECT *

    FROM fn_trace_gettable

    ('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc', default)

    The location above is the default location for traces, yours may have been altered.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]