Perhaps you should show us more detail about your schema. Why do you have 300 tables that require the same processing? Maybe you need to set up a procedure that uses a cursor to cycle through your tables. SQL Server has system-defined views that should allow you to do this. -------------------------------------------------------------------- Ed McCarroll (310) 838-4330 Ed at ComSimplicity.com http://www.ComSimplicity.com