Yes, I tried to open it and it opened fine. Now I see that it shows the file size. I think its showing the size after the specified time has...

Lowell,

I already stopped the trace by executing

exec sp_trace_setstatus @trace_id,0

@traceid in this case is 2, and when executed I get the result command executed successfully. but the file size is still...

Also, I set the end time to a later time in the code that I used for tracing. But had to stop trace in the middle (before actual complete time...

Also, when i query select * from sys.traces the status column shows 0 for my trace that has id as 2.

Just an FYI...I have the total index size as 30GB and I have increased my transaction log size to 50GB.

Hi Kubicek,

I have written a cursor that identifies all the indexes on tables that are not being used. Interesting in our case nothing showed up. The results were blank on...

Thanks for your reply...I will do some reading on how B-tree structures store data.

Thank You.

One more thing...can we increase the trace file size while the trace is running?

Thanks Guys...I have cancelled the ones I used earlier...i will be running it with switches after hours

I cancelled the DBCC CHeckDB query ...does it impact anything?

Is there a way to find the actual executable that is using the sql authentication in connection strings.

Thanks Lowell...I am able to see from a host ".Net SqlClient Data Provider" as the program name logged multiple times...so is that the actual application?

Thank you...i will try and get back to you

Thanks much for your responses...I was actually looking to identify if there is a way I can capture the connection strings of those applications when they hit the database :-D...