Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aaarrrgggghhh
Starting Member
6 Posts |
 Posted - 2004-10-20 : 08:59:28
|
| I have a SQL Server database and have discovered that due to the use of transactions in applications accessing it I need all the SELECT statements in my stored procedures to use the WITH(READPAST) optimizer hint. I could go through and change all my stored procedures to use this, however they number in the 100s and I'm short of time.Therefore I was wondering if anyone knew of a database wide setting or table setting that forces all SELECT statements to use WITH(READPAST)?Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-20 : 15:15:12
|
| No such setting exists.Tara |
 |
|
|
aaarrrgggghhh
Starting Member
6 Posts |
Posted - 2004-10-21 : 04:23:48
|
| Thanks |
|
|
|
|
|
|
WITH(READPAST)