tag:blogger.com,1999:blog-2740933809555086391.post9027462953320410731..comments2023-04-30T01:42:54.306-07:00Comments on Renewing Mind: ChMS - The Power of SQL ... and the importance of backupsrenewingmindhttp://www.blogger.com/profile/13383103615487227204noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-2740933809555086391.post-16673610617602475992009-04-13T09:24:00.000-07:002009-04-13T09:24:00.000-07:00I think we've all been bitten by that at one point...I think we've all been bitten by that at one point. A trick I learned at an old job (where we were constantly working in a production database) is to work with an open transaction until you're sure you didn't make a mistake.<BR/><BR/>For example, run this in SQL Management studio:<BR/><BR/>begin tran<BR/><BR/>update blah set foo = 1 where bar = 5<BR/><BR/>then verify that the # of records Anonymousnoreply@blogger.com