Ron - thank you for replying so soon. However, because I do not have access to the system tables the query does not work for me. Here is the error message I receive when I try to run it.
Msg 297, Level 16, State 1, Line 1
The user does not have permission to perform this action.
Is there a way around not using system tables? Thank you