I use simple text files, one per project, and UltraEdit (with tabs set to 2 spaces for brevity as I go up and down my stack). UE allows lines to be bookmarked,

I use simple text files, one per project, and UltraEdit (with tabs set to 2 spaces for brevity as I go up and down my stack). UE allows lines to be bookmarked, which works nicely for highlighting "to do" stuff. What is missing is tagging, but a few choice words and "find" is usually sufficient. Mmm... just noticed that when I make notes, I talk to myself in the plural! eg: ############################################################################################### Problem: SalesOrders table has 2,381 distinct SONum records, but 13,489 records. We've got AlienRef in SalesOrders, but the one from Oracle is per SalesLine. Let's drop it from that table. Need to fix the trigger code and SalesOrdersDeleted - done. Problem: insert Now fails on "Cannot insert the value NULL into column 'LastActivityUser', table 'Zeno_Dev.dbo.SalesReleasesAudit'; column does not allow nulls. INSERT fails." Fixed. Problem: There's duplicate SOnums in SalesOrders. eg: '100242032' SoNum 100242032 has TWO deliverypoints The addresses are the same, because we've got TWO customer numbers with the same delivery point. Aggh. CustomerID CustNum 3338 721180000 3550 721180015 DeliveryPointID, CustomerRef, DeliveryPointNum 13579 3338 S0015 13814 3550 S0015 When we create SalesOrders, we need to match on DeliveryPointNum AND CustomerRef ! Fixed.