Re: NO LOCK

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 10/22/04

Next message: KritiVerma_at_hotmail.com: "haing error with case"
Previous message: Mal .mullerjannie_at_hotmail.com>: "RE: Double Data Entry"
In reply to: DBA: "NO LOCK"
Next in thread: Andrew J. Kelly: "Re: NO LOCK"
Messages sorted by: [ date ] [ thread ]

Date: Fri, 22 Oct 2004 10:12:42 -0400

Sure:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

-- 
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"DBA" <DBA@discussions.microsoft.com> wrote in message
news:17CEA4C9-DAE0-446E-8A46-6C8CB7BEE34D@microsoft.com...
> This may sound dumb, but is there a way that I can do in SQL somthing like
a
> no lock command similar to what is in Progress

Next message: KritiVerma_at_hotmail.com: "haing error with case"
Previous message: Mal .mullerjannie_at_hotmail.com>: "RE: Double Data Entry"
In reply to: DBA: "NO LOCK"
Next in thread: Andrew J. Kelly: "Re: NO LOCK"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Restore points available
... Microsoft SQL Server MVP ... I support the Professional Association for SQL Server ... >> backup jobs so you can keep the size of the backup list down to a ... > Whoever had the brilliant idea of tacking DBA onto my job title should be ...
(microsoft.public.sqlserver.server)
Re: is this bad?
... >> able to make an informed decision. ... >> Tibor Karaszi, SQL Server MVP ... >>> effect the any DBA would be very unhappy with this. ... >>> I am using a stored procedure to retrieve data for an asp.net datagrid ...
(microsoft.public.sqlserver.programming)
Re: User function permissions
... Give execute rights to function ... SQL Server MVP ... > I have apps that use user defined functions in SQL 2000. ... The DBA before ...
(microsoft.public.sqlserver.security)
Re: Transactio Log reader... ???
... Tibor Karaszi, SQL Server MVP ... "DBA" wrote in message ... >> Paul Ibison)SQL Server MVP) ...
(microsoft.public.sqlserver.server)