great, thanks. that's perfect.

Thanks for the reply.

Will set up DDL tracers as you suggest. I didn't realise that about the default traces.

I have got to the bottom of the sequence of events:

1....

Ah ... apologies for not looking more thoroughly.

I'm also getting 'the initial snapshot for article ... is not yet available'. Unsure why it's all gone pear shaped...

Thanks guys!!! I'll take a look.

Appreciate your time.

Perfect, thank you too!

Oh right, I thought the variable would be evaluated first in it's () and applied to the rest of the statement but I guess I've got this wrong.

Thanks...

Thank you. Bit of a trauma just because I was unfamiliar with mirroring. Won't be caught out again.

Thanks. You're not misunderstanding. Sorry, it was a dumb question. I've just inhereted a mirrored pair & the tran log was full & the users were wailing...

Thank you both.

I would prefer to avoid dynamic sql but it's an option, & probly what I'll go for so thanks.

I need to run this on multiple servers,...

Or write your own ... jobs that run check procs & output to central db or powershell / dos cms that call procs you've written to check.

Or just print it out to fit A4 and get a really powerful monocle. Every good DBA should have a monocle.

Thanks, just what I was looking for.

Thank you both for your time & help. I do appreciate it.

xp_enumerrorlogs is perfect - can't believe I didn't find it before.

🙂

Hi Brandie,

I want the whole error log history.

So I'm logging the xp_errorlog outputs to a table variable at the mo. I could, as you say, just...

thanks for taking the time to reply, but i want to be able to write script that reads all of the error logs and pulls out x, y, z errors...