The default isolation level is SNAPSHOT for Azure? How can I make the default (not just enable it to be set) isolation level snapshot in 2008?
alter database MyDB set allow_snapshot_isolation on;
That command just allows people to issue this command:
set transaction isolation level snapshot;
With Azure, the FAQ states it is the default to use SNAPSHOT.