Thanks so much guys.

1. This query:

----------------------

SELECT * FROM LS20001...user_triggers

Returned:

---------------------

Msg 7314, Level 16, State 1, Line 1

The OLE DB provider "MSDAORA" for linked server "LS20001" does not contain the table "user_triggers". The table...

Lowell, first up, thank you for the quick response.

The question now is how come when I issue this query:

---------------------

SELECT * FROM LS20001..PPACT.user_triggers

I get this error? Our admin told me...

I've thought about it until management put up a rule that the admin should be able to edit the application form itself (e.g. add/remove fields).

Sorry if I didn't...

It's beautiful. Thanks for the quick response.