如何以编程方式获取SQL 2005中的事务日志的大小？

We're working with a fixed transaction log size on our databases, and I'd like to put together an application to monitor the log sizes so we can see when things are getting too tight and we need to grow the fixed trn log. We're working with a fixed transaction log size