Transaction Log Alert

[gcleffff]

could you please help me making a windows application in vb.net on alerting me when my ms sql transaction log gets full please help me!!!

 

[jmcilhinney]

I don't know what constitutes a full log file but I'm assuming that it is when it reaches a certain size, so you'd use a FileSystemWatcher, set its Path and Filter properties so it watches the appropriate file and then handle its Changed event. In the event handler you'd test the size of the file and act accordingly.