Skip to Content.
Sympa Menu

freetds - Re: Locking & SQL Server 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bob Kline <bkline AT rksystems.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Locking & SQL Server 7.0
  • Date: Wed, 24 Oct 2001 11:42:44 -0400 (EDT)


On Wed, 24 Oct 2001, Brian Bruns wrote:

> If it is the update statement from below that is causing the
> problem, you may need to check your index on LABEL_ID and make sure
> distribution statistics are up to date (anyone know if SQL Server
> still uses update stats?).

It's done automatically now, though you can still do it manually (and
it's possible to encounter some rare cases where that would be
appropriate). Probably not an issue here.

--
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com





Archive powered by MHonArc 2.6.24.

Top of Page