Its been months since i have'nt posted anything haha. I was addicted to photography indeed. Http://HumpreyCogay.BlogSpot.Com Any way i want to share one of my problems then. I've been coding SQL Querries for SQL Server for several years now, but working for the bank we use AS400 DB2 as a main...

My App Crashed a few days ago. And the culprit, SQL Server LogFile. So i searched for ways to monitor my Transaction Log File and i found this use MYDB; SELECT sysfiles.size * 8/1024 FROM sysfiles WHERE NAME = 'MYDB_log' It will return the exact value which is shown on enterprise manager whenever you...