I have tried using

sp_replmonitorsubscriptionpendingcmds

and although this provides me with the right data, how can I manipulate the columns output?

For example executing the above gives me two columns in...

Will give it a try, thanks.

Ok thanks for the clarification.

Also related to the index rebuild statement, how can I rebuild more than one index from the same table using the same alter index statement?

I have tried using a comma...

Thanks for that, will give it a try.

Yes I will check out Ola's script.

Ok will do thanks.

They work thanks.

Ok will do thanks.

Ok thanks.

Tried that. I get the following error:

Conversion failed when converting date and/or time from character string.

Ok I was afraid you might say that.....thanks.

Will do thanks.

Thanks, I've checked that data and tempdb has over 50% of free space left in it.

Would I be able to get the queries causing this issue by running a Profiler...

I've also noticed when I go into my tempDB database properties through SSMS I get the following error:

ERROR 1222 : Lock request time out period exceeded.

I killed a session which...

Ok thanks for your help.