Hi George

I ran your query and it returns the 2 queries I've been speaking about in this post.

Below is the SELECT query

)SELECT PaymentHeaderRefNo, Queue, System FROM PaymentHistoryHeader WITH(NOLOCK) WHERE SourceReferenceKey = @P

Below is the UPDATE that gets blocked. The SELECT completes quickly...within a second or 2. But...

The status for the UPDATE spid shows SUSPENDED

While the status for the SELECT spid (that is blocking the UPDATE spid above) showws RUNNABLE

Hi All,

I see this when I run sp_who2 'active'

I see a SPID doing an UPDATE...and it shows it's being blocked by another SPID. If I then do a DBCC inputbuffer...

Hi All,

Increasing the free space on the data file didn't work. I believe the reason ... because the index is a Primary Key Clustered index, the rebuild occurs on the...

Hi Steve,

Yes...definitly sure they are seperate files in the Primary file group.

Thanks

Denesh

Hi Jim,

Thanks for the reply.

No other errors in the logs except the one for same error that the index job is returning. The 4th file has only 1GB free space....

Hi,

Although your file is 350GB...is the file completely full? If not and there is free space...you could shrink the file to a size that will allow to you restore on...

Hi,

I've attached a screen shot from Profiler.

If you look at the line that is highlighted in the TextData column...it reads

declare @p1 int

set @p1=589

exec sp_prepare @p1

If you look at the next...

Hi,

It's in the TextData column.

It's actually the line before you the SP_EXECUTE

Hi All,

I believe SQL Profile will show it. Before the SP_EXECUTE, there is a SP_PREPARE statement that shows the SQL code.

Thanks

Denesh

Hi All,

Thanks again for the feedback. We eventually did a restart and all is in order. We also got Microsoft to come have a look. They believe it was to...

Hi All,

Thanks for the responses.

We have confirmed that the process in ROLLBACK is not being blocked.

Yes 13 hours is a long time however the process was running for 15...

Hi Gianluca,

The names I was using for the Data Source and the Product Name in the Linked server were not correct. It's now working!.

Thank you for your help

Hi Gianluca,

Thanks for the reply.

I have done that as well and that is what is confusing me. I've created a System DSN which tests succesfully. From what I understand, the...