Uninstall MS SQL Server Embedded Edition

1. Start Registry Editor, and then locate the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall
2. In the left pane, click each GUID. For each GUID that you click, look for a display name in the right pane that matches “Microsoft SQL 2005 Embedded Edition…”.
3. When you see a display name that matches the name, copy the value of the Key named “UninstallString”
4. Open a Command-Window (Start->run->cmd)
5. Paste the Copied string. It should be something like this: MsiExec.exe /X{BDD79957-5801-4A2D-B09E-852E7FA64D01}
6. Append “ CALLERID=OCSETUP.EXE” at the end of the MsiExec.exe eg “MsiExec.exe /X{BDD79957-5801-4A2D-B09E-852E7FA64D01} CALLERID=OCSETUP.EXE”
7. Run the command. This will go through the process of uninstalling SQL Server 2005 Embedded Edition
8. Reboot.

"Make files available offline" missing

1. Double-click My Computer.
   
2. On the Tools menu, press Folder Options.
   
3. Select the Offline Files tab.
   
4. Check the Enable Offline Files box.
   
5. Press Apply and OK.
   

MS SQL Server Error: The backup set holds a backup of a database other than the existing database.

In SQL Server Management Studio Express, when restoring, check the "Overwrite the existing database" option.

enabling MySQL in PHP on CENTOS 5

yum install 'php-mysql'

Running UBUNTU in under Microsoft Virtual Server

• Boot from Ubuntu’s install CD
  
• Then press F6, and at the end of the line add this: text vga=791 noreplace-paravirt
  

Drobo Review

I bought one of these when they first appeared on the promise that they are expandable without down time. Filled it with 2x500GB Samsung drives and it performed admirably, if a tad slow. I used it to back up machines and the backup files got fairly big and soon it filled up. I added 2 more 500GB drives and was pleasantly surprised when the extra capacity appeared within a few minutes without much fuss. The backup files got bigger ( >60GB each ) and then the problems started: It would start hanging from time to time and needed a power cycle each time to revive. One each power restart, the lights on all the drives would flash amber for several hours, with the warning message that the files are not protected. The problem grew slightly worse as the files got bigger and soon it had reach capacity. I started replacing the 500GB with 1 TB drives, and this was an ardously long process. The drives can only be replaced one at the time and each time, it flashed amber for several days before another drive can be replaced. Eventually all 4 drives were replaced and the backing up restarted in earnest and was met with a resounding failure. The backup files have now reach >100GB and not a single backup session was successful. Each time it would hang after several hours of copying, and after each power cycle, it would flash amber for a couple of days before turning green again. Tech support's only suggestions were always to either reformat the drive or update the firmware which were done every time to no avail. By now the drive was out of warranty, and stupidly, I bought a second one to see if the first one was unique. Sadly, the second one is exactly the same. Thus, the conclusion is to avoid it like the plague if you are intending to fill it with terabyte drives and copy very large files. I now have a proper NAS device with 4 TB drives for a little more money and it works like a dream. The only down side is that I can't upgrade the space without downtime like the Drobo promised.

Slow AD login away from AD domain

Trying changing Kerberos to TCP via:

http://support.microsoft.com/?kbid=244474

Sharepoint 3 and IE7 pop up name.dll problem

Open init.js in "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\1033\", find the function ProcessImn(). Delete the body of the function, i.e. :

function ProcessImn() { }

Windows Vista VPN Problem: "This connection requires an active internet connection"

Go to Control Panel - Network connections. Right click on the VPN connection and click "Connect".

FTP server not working on Windows 2003

1. Configure your firewall. Use the script from here: http://clintm.esria.com/2006/11/20/configuring-windows-2003-firewall-and-iis-6-for-pasv-ftp-port-range/
2. Make sure your anti-virus/anti-malware isn't blocking inbound FTP requests.

How to replace a broken default.master in SharePoint 3.0

If you mess up your default.master in SharePoint 3.0, you may get a "File not found" error on every page. To restore operation, use Windows explorer to go to the folder \\SharePointSite\DavWWWRoot\_catalogs\masterpage and copy a valid default.master file there.

Displaying record ID in Sharepoint 2003

Put the following javascript in the Dispform.aspx and Editform.aspx:

function urlparm( name ){ name = name.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\< /a>]"); var regexS = "[\\?&]"+name+"=([^&#]*)"; var regex = new RegExp( regexS ); var results = regex.exec( window.location.href ); if( results == null ) return ""; else return results[1];}

onetidPageTitle.innerHTML=' <h2 class="ms-pagetitle">ID: '+urlparm("ID")+'</h2>';

Get whois on an IP address in a web page

create a bookmark. Enter the following URL:

javascript:{var s = document.selection; var r = s.createRange(); var t= r.text; var w=window.open("http://whois.domaintools.com/"+t);}

Select an IP address on a web page. Click on the bookmark.

Set program output to environment variable in batch file

FOR /F "tokens=*" %A IN ('prog.exe') DO SET ENVVAR=%A

How to stop a META REFRESH

Use Firefox 3. Go to Tools, Options, Advanced, General and check the box for "Warn me when websites try to redirect or reload the page".