You probably need to use dynamic sql in your stored procedure. If more help, you will need to post the code.

Okay, I'm at a loss now also. If I think of anything before you resolve the issue (and if you do, please post back), I'll post here again.

From your desktop or the server? Did you run the ipconfig on your desktop or server?

I just glanced back through the posts and I didn't see answer to my question regarding how/where you are creating your maintenance plans.

I may just have missed it, though with...

Not really sure myself other than a entry with a NDS name that has the wrong IP address associated with it.

Just out of curiosity, have you run an ipconfig /displaydns to see what is there?

Nothing wrong with doing a t-log backup prior to a full backup. It will truncate the t-log reducing the amount the t-log that may need to be backed up...

Could it be a DNS cache issue? When you are creating the maintenance plans, are you "physically" on the servers or connecting from SSMS on your PC?

I know you...

What error messages are you getting when attempting to delete data?

Does this mean the virtual servers on the 2008 cluster have the same name as on the 2005 cluster?

Also, are there any error messages in the error logs?

It's out of my area of expertise, but I had a supervisor that told me that he...

Ninja's_RGR'us (3/4/2009)

---

Grant Fritchey (3/4/2009)

---

Ninja's_RGR'us (3/4/2009)

---

Holly crap!! If THAT GUY is an MVP, why the hell didn't I ever make that list?

Looks to me like we need about another 2000...

What is your normal way of writing dates: mm/dd/yyyy or dd/mm/yyyy. If the later, then that is probably why the dates in character format needed to be that way,...

Stepping out of my area a bit, but when you say the DNS changed, could you elaborate on that some more please?

Code ran just fine on my system. What is the compatability level of your database?