Skip to content

Instantly share code, notes, and snippets.

@kristinaconley

kristinaconley/NOLOCK for Linked Servers

Created June 4, 2013 16:09
Show Gist options
  • Save kristinaconley/5707202 to your computer and use it in GitHub Desktop.
Save kristinaconley/5707202 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
NOLOCK for Linked Servers
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SELECT * FROM LinkedServer.Database.dbo.Table
--Set back to original isolation level.
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment