In SSMS, i'm trying to list only the columns in a table that are bit fields. Reason being, there is a checkbox in our front end app that the customer wants "checked" (or set to '1') by default. Our engineers do not have a mapping that shows which sql field is mapped to that checkbox in their Delphi front end, and they are less than cooperative in providing the dba's with the info we need to get our job done, so we're left to use process of elimination go one by one and set the default values in sql to '1' until we see that box "checked" in the app. It would expedite things for me if i could produce a list of the bit fields in the tables that i suspect hold that column. Can this be done?
Second question: What's the best way to poison the coffee of an engineer without getting traced back to me?