Re: waiting for ole db resource and cannot Kill Process in KILLED/

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

stephanie (stephanie@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
But it locked the remote view that we can't insert or select with the
view.

Caught between a rock and a hard place then. Accept that the view is
out to lunch, or recycle SQL Server.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Grant access to applications only
    ... but to deny a direct user login e.g. via management studio. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
    ... I hope MS fix this livelock problem in the next service pack. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: IDENT_CURRENT and empty table
    ... >> And there is no definition what the result will be after fixing the bug. ... Books Online for 2005 is wrong and will be updated. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: sorting twice?!
    ... So I run a query to select the top 20 when ordered by datemodified ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Rolling up spans without breaks between them
    ... CREATE TABLE periods (start datetime NOT NULL, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)