For many years I was a consultant, usually called in after a clown such as this, and would never put such...

If you read your link, it keeps saying that Compatibility level provides only partial backward compatibility with earlier versions of SQL Server.

As Ninja said,...

Have you thought of creating jobs to periodically pull the data from these servers and write it to the new location? This would allow you to not have to worry...

This is why it is going to be a nightmare to maintain.

Please provide the schema's for the published databases and the schema for the subscriber.

Sorry - thought you were using SS2005. Going to stick then with the view. It would be the easiest in your case and for the future.

Again, check to see if the default binding will accomplish your requirement. Otherwise I would opt for GSquared's recommendation of creating a view over the 4 different variations of the...

I believe that setting the default binding to true will accomplish what you are asking, but...

Do they all have the same schema and name? If so, you'll need to replicate them into three different databases (so far as I know). You can then use a...

Great series Gail. Learned a lot as well as a great refresher.

Having read all of the posts to this point, I find it interesting the arguments for/against one RAID vs another.

In my opinion and experinece the RAID rule of thumb has...

cengland0

Oh, any my first modem was a 300 baud acoustic coupler.

Did you ever see the movie war games? They used one of those too. You take the receiver off the...

They flew so much better across the data center. How about the 5MB platters used to make the disk packs?:-P

cengland0

My first exposure to computers was a mainframe using magnetic core memory. You saved your programs on punch tape (like punched cards but came on a roll and was only...

Nice way to make some feel soo old:hehe:

Exactly. I would rather get it wrong on a QOTD and miss a...