I just had to do a bulk find and replace in MSSQL on a databsae to change PizzaExpress to Pizza Express. Instead of having to go into each one and change one by one I could just use the following SQL Query. Much faster! UPDATE restaurants SET restaurantName = REPLACE(restaurantName ,’PizzaExpress’,'Pizza Express’) WHERE restaurantName like ‘%PizzaExpress%’

Was looking at a WordPress install today on Windows. We had just installed the nice URL rewriter but new images, when clicked to their full size version were giving an error: HTTP Error 500.50 – URL Rewrite Module Error. Module RewriteModule Notification BeginRequest Handler StaticFile Error Code 0×80070005 At first I thought this was a problem with the URL Rewriter, however a bit of digging around showed it was a problem with Permissions. When WordPress [...]

Was on one of my Windows 2003 Server machines and trying to run Microsoft Update. However when running I was getting an error 0x800A1391 To fix I needed to do the following: Start Internet Explorer. On the Tools menu, click Internet Options. Click the Security tab, and then click Trusted Sites. Click Sites. Click to clear the Require server verification (https:) for all sites in this zone check box. In Add this Web site to [...]

Started having problems on my machine today where opening an application I got an Office 2007 installation window and then the error “Error 1907.Could not register font. Verify that you have sufficient permissions to install fonts, and that the system supports this font”

Microsoft Excel 97 may return the following error message when using DAO 3.5, if an application created with Visual Basic 5.0 that uses DAO is installed.

When setting up a port for printing via tcp in NT4 the LPR port does not appear