Where printers have been removed can cause issues with the user report program where you can control where users print to. The code below simply looks at the printer table and compares with the report control table. BEGIN TRAN –Check number of records which have invalid printers SELECT * FROM “scheme”.”wh_rctl” WHERE NOT EXISTS (SELECT…

Continue reading