Post reply

We just upgraded to SQL2000 and are having a lot of locking.

  • August 26, 2005 at 7:43 am

    #91001

    I upgraded from SQL7 to SQL2000 Service Pack 3 last weekend.  Since then we have experienced "mucho" locking with our business system users.  I'm wondering if other DBAs out there have experienced such an occurrence after upgrading to SQL2000 from SQL7? My guess is that I have to adjust a configuration value related to locking.  Any help out there would be appreciated.

  • August 26, 2005 at 1:33 pm

    #585594

    If your databases are not large you can create a blank SQL Server 2000 database and move the data through BCP or INSERT INTO and DTS.  The reason SQL Server 2000 have DRI (declarative referenctial integrity) and SQL Server 7.0 had only DRI Triggers.  Hope this helps.

    Kind regards,

    Gift Peddie

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply