SQL servers and mob wars

Yesterday was yet another busy day.

Have I ever mentioned how much I hate replication on SQL server? It should be straightforward, and there are plenty of helpful looking wizards to automate copying data between two servers – only trouble is that they don’t work. If you set it to drop the tables and recreate them in the target, then you also lose any views built on that data. If the target database is different to the source (for example if the source has been changed by the programmer, and you haven’t dropped the tables and recreated them) then the routine will fall over with an obscure error message in the replication log. Oh, and if the database is on the other side of the firewall then FTP is the only way to copy the snapshot file across. Still, it’s working now, and I’ve only got the problem of the data error that’s been causing the integrity check in the maintenance plan to fail, and also stop the backup from working as well.

Still, The Godfather continues to be excellent. It’s not on the same scale as San Andreas, but it improves on it with the number of bars, restaurants, shops, hotels, nightclubs and gambling dens that are there for the taking. The story missions are excellent too, and there’s a real buzz from being on the periphery of some of the well known scenes from the film – watching Luca Brasi getting garotted, driving the Don to hospital and wandering around the Corleone compound. ACEBEST!