Error 29506 | SQL Server 2005 Management Studio Express

When i binged (yes I’m using bing :P), i found the following fix:

  • Search for Command Prompt in the Start Window (don’t press enter)
  • Right click on the shortcut found and select ‘Run as Administrator’
  • In the command prompt change the current directory to the folder where the SSMSEE installer is stored
  • Enter the following command .SQLServer2005_SSMSEE_x64.msi if you are running Windows 7/Vista 64 bit
  • Enter the following command .SQLServer2005_SSMSEE.msi if you are running Windows 7/Vista 32 bit
  • Press enter to start the installation

Happy Sql Server Managementing 🙂

Resources: here

Cannot Delete Folders in Windows Vista

Sometimes when deleting a folder first the UAC fires up and you’re asked to continue. Then the user is prompted “Cannot delete Folder: It is being used by another person. Close any programs that might be using the file and try again”. Of course other prompts you might see include:

  • “Cannot delete file: Access is denied”
  • “There has been a sharing violation”
  • “The source or destination file may be in use”
  • “The file is in use by another program or user”
  • “Make sure the disk is not full or write-protected and that the file is not currently in use”

First let’s figure out the Problem:

Let’s say you have the main folder named ‘folder1‘, and in it there’s another folder aka ‘folder2‘. You try to delete folder1 but an Access Denied prompt is loaded. What should I do? There are three solutions..

  • The Simple Solution
  • The Slow Solution (but easy)
  • The Fast Solution (but technical)… after the break…

Continue reading