I got an error while executing a Job that is accessing (SELECTing) a linked server table. Error Message Msg 229, Sev 14, State 71, Line 1 : SCHEMA LOCK permission denied on object 'SystemIDX', database 'lecus', owner 'dbo'. [SQLSTATE 42000] systemIDX is the table in the remote server. and the query that is accessing this table is... SELECT TOP (100) PERCENT * FROM dbo.v_lecus_System_Idx When running the same job 30 minutes later, it ran fine without errors. And, i did not get that error earlier and after that. As per my understanding while creating/modifying execution plan for a query or compiling it will cause a schema stability lock. But what could be the reason to deny permissions on that the first time and allow it next time?