aionine
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?
chapmandew
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
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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.