Hi Steve

Found that the extended event logger was running as a...

Thanks for feedback Steve

Eventually I found a clue here...

https://dba.stackexchange.com/questions/102158/sql-2008-r2-agent-stopping-sp-who2-running-and-cant-view-database-or-agent-prop

So I recreated the problem

-- To allow advanced...

Hi Perry

Note : I hope this won't get confusing as my name is also Perry!

Take this scenario...

2 node active/passive cluster - SQL 2008 R2 on Windows 2008 R2

All data, log,...

I guess I must be one of those people with a tidy mind but this is something I am quite passionate about.

Having said that there is no need to be...

Thanks for the comment A.J.

Fortunately the client side code is 99% stored proc calls, and we're working on converting the remaining to sp's.

I'm still not convinced changing to dbo. prefix...