Vivien,

Thanks for the tips. I do run dbcc showcontig along with the "with fast" options.

Here is the full command I run:

dbcc showcontig with fast, tableresults, all_indexes

The command...

Note: This is occurring in a SQL Server 2000 environment.

Thanks All. I have been comptemplating using the FAST option. I'll make sure it give me all the info I need and give it a shot is so....

Francis,

You're right, this command should not have taken over 4 hours. It has finished in no more than 30 minutes in the past. Something occurred during...

Thank you everyone for your feedback. I think I will take the path of sending out a notification that the log file is becoming large and then set up...

Matt,

Thanks. I perform a dbcc dbreindex / dbcc indexdefrag weekly - during off peak hours. We don't defragment our drives because they are on the SAN....

I found the way to manually force a file to grow...

ALTER DATABASE <database name>

MODIFY FILE

(

NAME = <file name>,

SIZE = <size in MB>

)

I'm still curious as to how long it wil...

Jimmpy,

This has happened to me in the past as well.  Since we can run sp_who2 from any database, it's possible it was run while connected to the database that you...