Post reply

View has schema table lock and pevents reindex

  • July 9, 2008 at 9:03 am

    #70456

    I have a stored procedure which runs a dynamic SQL query against a view. For some reason the sql maintains a schema table lock on one of the tables in the view after completion of the stored proc. This happens intermittently.

    Then when my DB Maintenance Plan tries to run its optimizations job it hangs. I ran profiler when the optimizations job was running and found that it hangs up when it tries to reindex the locked table.

    How can I make sure that the lock is released when the stored procedure completes? Or at least before the Maintenance Plan runs.

  • July 9, 2008 at 3:42 pm

    #840544

    Would be helpful if you can paste the stored proc. and view code here. Also, are you making use of any table level hints in stoed procedure or view code?

    Manu

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

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