Yep, I agree with your sentiments too! Just because SSIS was not working exactly how the original poster thought it should, is no reason to rubbish SSIS in general. Still,...

I agree, fix the problem at source. If the source data was in ISO date format, SSIS would have no trouble importing it, because the date format is not...

You need to consider how "out of date" the database at Mumbai is allowed to get. Plus how often the link is liable to go down; for example, if the...

ahhh, that must be due to a Transaction Delay threshold being exceeded. I get that a lot with Database Mirroring. Coffee normally helps 😛

Hi ALZDBA,

Thanks for your input. But isn't that what I said? I didn't dig deeper as to whether a Witness (and thus automatic failover) was involved, or whether the mirrored...

When the link between Pune and Mumbai goes down, do users update both databases (Pune users update their local DB, and Mumbai users update their local DB)?

If yes, then database...

Do you have any direct experience of PolyServe? I am currently evaluating it for possible deployment.....

Andy

The majority of Microsoft exams can be taken by anyone, in any order. Probably the only exceptions are the upgrade exams, where you must have first passed the relevant exams...

gah, I knew someone would ask an awkward question :hehe:

Just being slightly provocative, as I keep hearing that VMware is not suitable for mission critical apps. It certainly is suitable,...

With VMware Infrastructure and VMware HA (High Availability), in many ways I am more comfortable running mission-critical apps in a VM than on a physical server.

And when was the last time you checked the conflict tables for any problems? Are you sure all of your Identity columns are incrementing correctly on all Subscribers? How do...

With VMware VirtualInfrastructure, you can add more CPUs and more RAM to a VM, as and when needed. With some provisos, this...

I've not really paid any attention to this before, but you are quite right - when Windows Authentication is selected, the username defaults to the current logged on user and...

My 2 cents is that if you have 5 SQL Servers, each ticking over at 10% utilisation, then they are a good case for virtualising. You won't hit any problems,...

Or download a 90-day trial version....

Or buy the Developer Version for very little money....