Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187

    Unanswered: DROP INDEX gets Msg 3624

    Hi all,
    Please help.
    I am running into problem of droping an Idex.
    My statement is:
    DROP INDEX tblPkgInfo.Tracking

    I get the following:
    Server: Msg 3624, Level 20, State 1, Line 1

    Location: recbase.cpp:1371
    Expression: m_nVars > 0
    SPID: 51
    Process ID: 2068

    Connection Broken
    -----------------------------

    What do I do?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    What do you get when you run DBCC CHECKTABLE (tablename)?

    where tablename is the name of your table

Posting Permissions

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