Hi Gail

I looked at the code that a previous DBA implemented and it looks to be a DBCC DBREINDEX with no options supplied, reading Microsoft articles I am unsure on...

I am not sure it was a user query. The SPID was the same SPID number as the DBCC DBREINDEX.

Hi there, it seems we do have DDL changes on. The problem I have been told however is that the application does a drop and create of the tables...

Just so you know the restart of the sql server fixed this.

Quest suggested that the litespeed dll could have been held which is why the log backup did not roll...

Hi - thanks for the replies.

Yes we tried the log backup but as you stated it was blocked by the rollback. At the time the log backup...

Thanks for the reply. We are using SQL 2008 SP1 Enterprise edition.

I have been reading here however where people have suggested a restart is needed:

http://connect.microsoft.com/SQLServer/feedback/details/433703/killed-rollback#details

However this is further complicated...

lol omg what a numpty - sorry to bother you with that, but thanks for your time.

Hi there thanks for the replies. My linked server is setup such that my account is linked to a remote user that has access to the database in question.

The...

Hi there - I am experiencing exactly the same problem with the same code being executed on a SQL 2008 RTM. Does anyone know if this is a bug?

ok thanks will check it out

I am using a Sharepoint list as my datasource so don't think I can do it that way.

Thanks though

Why a must after the update, does updating break the log chain?

ah cool - its the is_subscribed field I am interested in however, thanks.

Sorry for the slow response with this, thanks for the help I will work through the code.

Apologies - The output should look something like this

SELECT *

FROM(

SELECT 'Systems Team Applications', 'mathurp', 'grayj', 'rheat'

UNION ALL SELECT 'Systems Team Applications',...