SQL Server error "The changes you have made require the following tables to be dropped and re-create

When making changes to SQL data tables in SQL Server 2008 you may have come across the error "The changes you have made require the following tables to be dropped and re-created".

Remove SQL Server

Follow the below steps to remove an installed instance of SQL Srever 2005. The steps include removing the SQL Server from Add or Remove Programs

How to Fix IIS in Windows 7 error "PageHandlerFactory-Integrated" bad module "ManagedPipelineHandler

After building a simple ASP.NET website in Visual Studio 2010 and transferring the site to IIS web server you may encounter the follow error: HTTP Error 500.21 - Internal Server Error Handler "PageHandlerFactory-Integrated" has a bad module "ManagedPipelineHandler" in its module list.

Install IIS on Windows 7 or Vista

To install IIS (knows as Internet Information Services) on you Windows 7 or Vista carryout the following steps.

Create animated gif files in Adobe photoshop

Watch the below video on how to create animated gif files using Adobe photoshop

https://www.youtube.com/watch?v=Qtar5T13dt8

Show Developer tab in Excel

1. Open Excel

2. Click on the Excel icon on the top left corner

Get URL from Hyperlink in Excel using VB script

To get and transform a hyperlink in cell(s) contained in an Excel worksheet you need to create a small VB script snipet. You need to put the VB script in a module in Visual Basic editor. Follow the below instructions to create a function in Excel to get the hyperlink from Excel.

Low density RAM memory

The density of a memory chip is classed into Low and Density.

Onboard DVD drive or SD card reader not seen in Windows

The easiest way to fix this problem is to find the non working device in your computers Device Manager and uninstall the device and reinstall it by detecting new hardware. This process can be applied fix other hardware devcies that are not shown or recognised by Windows OS.

Setting up an ad-hoc (computer-to-computer) network with internet connection sharing (ICS)

This type of network setup connects several computers usually wirelessly to each other. You can use this type of network to share the internet over the wireless network without the need for a wireless router.

Internet connection sharing on Ad-Hoc network

If your normal internet connection sharing is not working, you can bridge the ethernet connection and the wireless connection on the computer with internet access. This will allow other computers connecting to the ad-hoc network to access the internet through this computer.

How to install Windows 7 DVD from a second bootup disk

If your Windows 7 DVD doesn't bootup from you DVD write/rom even though you have changed the BIOS setting to boot from CD/DVD then there may be something wrong or corrupt on you bootmgr of you Windows CD.

Create a Windows 7 bootup disk

If your Windows 7 become corrupt ot fail to boot, you will require a Windows 7 bootup/repair disk.

How to setup a Workgroup in Windows

To change the Workgroup in Windows 7 follow the below instructions:

To change a network location type

If you want to enable your computer for file and printer sharing and turn on the network discovery, you will may need to change the the network type from the Network and Sharing Center.

How to set up File and Printer Sharing on Windows 7

Make sure that all connecting computers are on a Work network for Windows 7 and Private network for Vista and XP. File and Printer sharing will not work on Public network type due to security reasons. Network discovery must be turned on. To change the network type click here.

How to Create a Partion in Windows

1. Goto Control Panel

*if in default view

2. Goto System and Maintenance

The CD drive or the DVD drive does not recognized in Windows

The CD drive or the DVD drive is NOT coming up in Windows Explorer. The problem occurs when the CD drive or the DVD drive is NOT recognized by Windows operating system. The device manager shows an warning sign.

How to remove USB device without "Safely Remove Hardware"

occasionally, for reasons unknown, the "Safely Remove Hardware" icon can disappear from your system tray.

Even though the devices are still installed.

Create a new partition in Windows

1. Log on as administrator or as a member of the Administrators group.

2. Click Start icon,

Fix Hard Drive errors

1. Click on Windows icon (in Windows 7 and Vista) or the Windows Start (in XP)

2. Click on My Computer

How to restore Network icon in system tray

  • Right click the Task bar.
  • Click Properties. This takes you to Taskbar and Start Menu Propeties
  • Click on Notifications Area tab

Access Windows Registry

  • Click the Windows Start Menu, the Windows icon in left corner of the screen
  • In the Search box type regedit and press Enter
  • Click on regedit.exe link given by the search result. Below is an image of Windows Registry Editor

 

How to restart explorer.exe

  • Right clcik the Trak bar. Below is an image of the Task Bar

Login here to publish helpful and technical articles.

Once you have logged in you will be able to submit articles by clicking the link below. *Note the link will only appear to registered users when logged in.

Google Ads

 
 
 

------------

Search