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: nolock, remote server, select + (nolock), Select data from two servers, SQL (Structured Query Language), sql server, sql server 2005
