http://blogs.technet.com/mat_stephen/archive/2005/01/31/363803.aspxSometimes I hear the comment that someone can’t get their application to scale above 50 – 100 users; above a certain number of users there is a sudden ceiling in scalability. So often I have found this to be a problem with nothing more than SQL Server’sen-GBCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.technet.com/mat_stephen/archive/2005/01/31/363803.aspx#363821Tue, 01 Feb 2005 00:00:00 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:363821Phil MattsonCool link and article... I learned something new today!!!http://blogs.technet.com/mat_stephen/archive/2005/01/31/363803.aspx#363835Tue, 01 Feb 2005 00:17:00 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:363835Soumitra BanerjeeIs there a way to force SQL Server to use row locks only?http://blogs.technet.com/mat_stephen/archive/2005/01/31/363803.aspx#363842Tue, 01 Feb 2005 00:27:00 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:363842Matthew StephenYes - the methods described in the article will force SQL to only use Row locks