I was using following query
select top 10 * from [sqlserver02\sqlserver02].mydatabase.dbo.aspnet_membership (nolock)
whereas “sqlserver02″ was a remote serever and I found following errro
Msg 4122, Level 16, State 1, Line 1
Remote table-valued function calls are not allowed.
Then I remove (nolock) from the query and it worked.
Does any one know why remote serever doesn’t allow (nolock)?
