Florian Pflug <fgp@phlo.org> wrote:
> Yeah MS-SQL really isn't the idea target for comparison here. You
> can override pretty much any lock that MS-SQL takes with a
> stronger or weaker one from what I've seen. I wouldn't be at all
> surprised if you could convince it to work either way by putting
> some (probably rather obscure) incantations into your SQL
> statements.
I was thinking of some of the ALTER DATABASE SET options, like
COMPATIBILITY_LEVEL or ALLOW_SNAPSHOT_ISOLATION, but you have a
point about what overrides can be used at the statement level, too.
-Kevin
