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

Previously jokiz bloged about this one , I'd like to add further. The same issue cropped up again in the forums although not the exactly the same as jokiz's experience, this one could really give you hours of head scratching. Previously I was amazed that dynamic ORDER was possible with T-SQL without...

During my last post try to query the actual size of the logfile, and today i'm going to share a script i found months ago at the microsoft site. I cant find the original link.... Notes: Be sure that you have a backup of your database so that if something goes wrong you have something to get back into...

Didn't you know that the following statement is now valid for Sql Server 2005 as criteria for a column with bit data type? SELECT * FROM Orders WHERE Processed = 'true' The engine is now intelligent enough to implicitly convert it to SELECT * FROM Orders WHERE Processed = 1 More readable, imo. Too bad...