I just joined a company that uses SQL 7.0,which am not that much used too. i can view 'code' for views with 'INFORMATION_SCHEMA.VIEWS and can view triggers and other objects with 'sysobjects' i want to view the code for the triggers in a particular table... PLEASE HELP ME...THANKS