Using (nolock) with SQL Select Query in SQL Server 2005





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)?




Tags: , , , , , ,

Comments are closed.