I was asked by a friend of mine on how to create a trigger that would trace the changes that a user did to a table. So i checked my bookmarks and give him this link http://www.nigelrivett.net/SQLTriggers/Triggers_2_Creating_Audit_Trails.html Hope to Get some of your opinions or maybe improvements on...

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...