As was stated above it doesn't have an effect on READ COMMITTED or READ UNCOMMITED, but it has a big effect if your isolation level is set to REPEATABLE READ or SERIALIZABLE. So, the answer is it depends on isolation level.
Microsoft Certified Master - SQL Server 2008 Follow me on twitter: @keith_tate
Forum Etiquette: How to post data/code on a forum to get the best help[/url]