Correct he was saying he couldn't see the list of tables in SSMS. I will run the script tomorrow when I get back to work 🙂

No was a new login

Seems not too bad apart from when the job fails without re-enabling the other job, then manual intervention would be required. I appreciate the reply non the less.

Thanks

Hi - Thanks I think I understand now, its doing the join when the bl.LogDateTime is between the dates in the SYSUSERLOG table.

Thanks

Hi - thanks for the reply

What I don't understand though is what values is it applying as in what dates is it looking between?

Hi all thanks for the replies. No this was not a recent replication, although was being re-initialised at the time. It happened at the Publisher so I am...

Hi thanks for the reply, I had already done everything you suggested apart from one aspect. You mentioned drilling down through component services to remove from there, however there...

Hey thanks for looking, just to be clear though there is not clustered resource in Failover Cluster Manager, its just present in Component Services. You can't even look at...

Hi - Its windows 2008 R2. I have not tired setting up any other type of cluster, however if I got to component services it is a clustered MSDTC...

After uninstalling SQL its not longer in cluster manager, it was part of the same group.

Well the box has been rebooted several times and still does not fix the problem.

Hi - Ok I have re-installed LITESPEED and the whole instance still crashes.

The command I am running is:

DECLARE @ReturnCode int

EXECUTE @ReturnCode = [master].dbo.xp_slssqlmaint N'-MAINTDEL -DELFOLDER "\\BKPMEDIA5\DBTEST\DBTEST$TFS\master\FULL" -DELEXTENSION "bak" -DELUNIT...

Ahhh ok - thanks

I am using Ola Hallengren's scripts http://ola.hallengren.com/ and the error was pulled from the log files it creates, of which it looks to be a custom one of Msg 50000,...

Fair enough I will give that a whirl, thanks.