Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Unanswered: sql2000 schema stability lock

    HI guys,

    i got schema "stability locking" problem in sqlserver 2000.
    i have a application which appends dailydata table to masterdata table, while appending schema stability lock is acquried, so my application waiting a lot of time to insert daily data to master table.

    ex: query in my application is ..

    INSERT INTO MAINTABLE SELECT * FROM DAILYTABLE

    i rebooted my server and restarted the process again, eventhough i got the same problem again and again, there is no other process accessing the same table.

    is there any way to reslove the problem ?

    thanks in advance
    raj Kumar

  2. #2
    Join Date
    Feb 2002
    Location
    Sweden
    Posts
    34
    Is that the only command sent?
    schema locks shouldn´t be aquried when modifying data (maybe when sqlserver is compiling, not sure)..
    Do you get an schema lock if you run the same sql from QA?
    Are you running inside a transaction? high isolation?
    - Jonte

  3. #3
    Join Date
    Jul 2003
    Location
    London
    Posts
    26
    Hi Try to be explicit when using INSERT and SELECT statements. I forgot why you need to do this, I think it is do with the query plans and how they are generated. The fact that you do not specify which columns may be the reason why the schema being lock.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •