The problem with creating a temp table gives the following possible errors

--There is already an object named '#temp' in the database.

Second I need business logic in the like '' for...

That's indeed what's required, the sites are also...

It's a habit of mine to use where 1 =1 cause then when i need to add/remove filters I don't have to remove the where only 'and'

I actually agree with both of you but it's out of my hand, I'm limited by what the architecture allows me.

And I can't change the architecture, if I could I...

//Brilliant I made the post with my text not appearing so here goes the edit

The scenario is a bit more complicated then I initially described, we have to 'merge' data...

Jason Selburg (10/31/2012)

---

Luis Cazares (10/31/2012)

---

It's hard to be sure about what you need to do, but as I uderstood, you have a Sites table that is referenced by the OrderHeader...

No it would not its still a 2008 r2 server

Matt Miller (#4) (10/10/2012)

---

If I may ask - why is there a hangup about making a connection to the server?

If you can dynamically build the connection string to multiple...

That's kind off what happens,...

Yes, but I believe that in Oracle you don't have a single rdbms to manage multiple database, I could be wrong in this aspect been at least 18 months since...

Ok, that's basically what I told him, but he wanted me to look it up anyway.

He asked because you can do it in Oracle, but that is cause in Oracle...

It was an interesting article to read, I agree that database recovery can be hard and this tool will be helpful.

But I also get the impression that MS is dumbing...

Thanks that was exactly the answer I was looking for

While the topic is interesting why would you need to have this.

MS SQL server already has plenty of backup tools, it would be handy for those rdbms that rely on...

In an age when animal could still speak...

Ok, not that long ago, about 12 years ago I got my first programming lessons I used the GOTO instead of using OO...