USE CompanyA SELECT * FROM EccUser WHERE Administrator='Y'
The above lets me search the EccUser table in the CompanyA database for rows where the Administrator column is = 'Y'
How do I look in any column in any table for 'Y'? Do I use SYSCOLUMNS? How? (I am on ms sql 2000 if I need to use ps_MSforEachTable or ...EachDB by the way.)