Almost 2 months ago Steve Harman, showed a ugly character map used in a database field to store the week's working days.
Today I came across something similar, or maybe even worse, since the super-smelly database field is used in some system SPs in SQL Server 2000.
I found a few examples of inconsistencies and "strange" implementations but let's focus on just one system stored proc: sp_help_job.
This SP is used to retrieve a list of jobs or, if called specifying a GUID, it returns 3 result sets with the steps and schedules of a single job.
Let's see some examples:
enabled, which can be...