Hi

Thank you everybody . we used execution plan and found out an index offer then created this index and the problem solved.

hi

I 'm in the same situation and finally i had to create a stored procedure that runs my job and i grant execute this Sp to my user . but...

Thank U soooooooo much:-) .i didnt check MSDTC not at all .and it was the mistake.now i want to create update Trigger for this table.how can I do that ?

actually i want to create trigger on table which has a XML column , and i got error that cant use table with xml column in distributed queries.then i changed...

Tnx !

Unfortunately,it seams that i cant do anything...

You can add your users to db_ddladmin role !:D