| Hilary Cotter 2006-11-08, 7:12 pm |
| No, but in SQL 2005 you can do this by using the snapshot isolation level.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ashok" <Ashok@discussions.microsoft.com> wrote in message
news:41FB7A0B-0396-49F9-8632- 4E24DD257ADB@microso
ft.com...
> In SQL Server 2000. Can I set
> SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
> At database level?
>
> I want my all stored procedure to use this and don't want to code in SP. I
> understand the impact but still like to test.
>
> Thank you - Ashok
|