Thinking
Thursday, August 23, 2012
Check and Change isolation level of SQL Database
ALTER DATABASE EFORMSDEV_LC SET READ_COMMITTED_SNAPSHOT ON GO ALTER DATABASE EFORMSDEV_LC_PM SET READ_COMMITTED_SNAPSHOT ON GO SELECT name, snapshot_isolation_state_desc, is_read_committed_snapshot_on FROM sys.databases
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment