I want to find an individual database log file. Besides dbcc sqlperf(logspace), is there any T-SQL command that will provide this file?

From the user database context in SQL Server 2000, use the following statement:

SELECT * FROM sysfiles    WHERE (status & 0x40 = 0x40)

This statement also works in SQL Server 2005, but a better alternative would be:

SELECT * FROM sys.database_files     WHERE type = 1

—Gert Drapers
Development Manager
Visual Studio Team System