Unfortunately someone took the manual home, and I need to figure this out as quickly as possible. How do you ask SQL Server 2000 to set locking granularity to record rather than page (still allowing it to escalate to page or table level if it needs to).

Thanks

Gar