alter your procedure like this:

select * from Customers where Id IN(select * from MainDb.dbo.MainAcc)

if your MainAcc's owner is not dbo replace dbo with proper owner or use MainDb..MainAcc

but it is...

check out "TextCopy " in BOL

TRY this:

select *

from blah a

where not exists(select *

from blah a

where a.a=b.a AND

((a.b=b.b AND a.c>b.c) or (a.b>b.b))

)

quote:

---

You can use the ALTER TABLE command to disable and enable triggers. Also you can use sp_trigger created by Rodrigo G....

is it possible to avoid dropping TRIGGERS ?

--YOUSEF