Remote table-valued function calls are not allowed.

Normally, when we access any objects(Table, View....) from Remote server using Four part naming convension through Linked Server as given below...

Select Column1, Column2 From Server2.Database1.Dbo.Table1(NOLOCK)

The following Error occurred...

Remote table-valued function calls are not allowed.

Solution:
Select Column1, Column2 From Server2.Database1.Dbo.Table1 WITH(NOLOCK) instead of NOLOCK

This error will not occur, When we access the Objects from different database or same database within the same instance or server. But, when we go to different Instance or server, NOLOCK should be used along with WITH keyword(i.e: WITH(NOLOCK)) instead of NOLOCK

1 comment: