Forgive my ignorance here.....

Can you explain this ? Are you saying...

So are you saying there is no way to check what raid levels i have configured ? Do i just have to take our suppliers word that we have a...

I can ping...

These servers are in a production environment. I am not sure if these have been able to connect via name previoulsy as i am new here.

I have just managed to...

ahh Sorry i misunderstood. Presumed you meant ping by IP.

No i cannot ping by the server name but i can ping by ip.

I will try a FQDN and see if...

I can actually connect via the ip address so network connectivity is fine. I just wish to connect via the name though.

I just type in the server name in the...

Thanks for the suggestions everyone. I think i will go with Gail's suggestion - i have just tested this method using Redgates sql backup pro - it actually gives you...

Thanks Gail. I thought as much - just needed confirmation. 🙂

Thanks for sharing that link Gail.

I copied the showplanxml.xsd from an sql2012 version and copied into into my sql2008 version as the article mentioned - All links now return the...

Ok Thanks for the reply - i will give that a try - Thank you

🙂

Ok. I'll try to explain a little better.

I have 20 servers, each one with about 10 - 15 databases on each.

I want to set a weekly scheduled job to run....

Scot - your suggestion worked. I had to enable the MSDTC service and now the distributed queries run.

Thanks for the pointer !

🙂

Hello.

I have managed to fix the problem. If anybody has got a problem with Multi server jobs using a CMS where the status says blocked then read on....

In the end...

guys - thanks for all the help. @luis you where correct - i was just missing the quotes !! It was a late night and sometimes you just cant see...

Ok Grant no worries.

I thought i had fixed this problem. When we run it inline as the simple update with the removed cast function it runs perfectly, but, when we...