How can I query a SQL Server 2000 database to output the table name of all tables that contain a particular column that it itself contains a particular data? For example I have many tables within the mailing database with a column called 'SENT' which can contain data of either '1' or '0', so how can I display a list of all the tables from the database that contain a SENT column value of '0'?
Thanks in advance.