asked on
READPAST error
I am using WITH (READPAST) hint in some embedded queries from .NET application to SQL Server 2005.
I am not setting the isolation level anyware, so presumably its the default READ COMMITED.
I am getting error:
"You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels".
Any clues?
I am not setting the isolation level anyware, so presumably its the default READ COMMITED.
I am getting error:
"You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels".
Any clues?
Microsoft SQL Server 2005
Last Comment
aionine
are you doing it on a view ?
ASKER
No, but I use joins, if this is of any significance:
SELECT SC.*, A.SiteGuid
FROM dbo.RGSiteConfig SC WITH (READPAST)
INNER
JOIN
dbo.RGAccount A WITH (READPAST)
ON A.AccountGuid = SC.AccountGuid
WHERE SiteGuid = @siteGuid
SELECT SC.*, A.SiteGuid
FROM dbo.RGSiteConfig SC WITH (READPAST)
INNER
JOIN
dbo.RGAccount A WITH (READPAST)
ON A.AccountGuid = SC.AccountGuid
WHERE SiteGuid = @siteGuid
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I guess I'll try that.
I am not exited though :-)
I am not exited though :-)
Im not "exited" either. :)
ASKER
It seems to solve the problem - no errors have been reported since.
Strange it was needed, but that makes this solution excellent.
Strange it was needed, but that makes this solution excellent.