We had a customer who was having trouble removing a SQL Server constraint. Even removing the column and re-adding didn't help.
You can't even DROP INDEX command.
The trick is to use ALTER TABLE command with DROP CONSTRAINT
Example:
alter table dbo.Projects drop constraint [UQ__Projects__46B27FE2]
Viewed 51 Times
Date Blogged: 3/7/2010
How to Download Microsoft Office
The very nature of software (intangible, intellectual work involving half-art-and-half-science) renders itself to complications of licensing.
We help all our customers buy legitimate software and licenses.
One of the most commonly misunderstood usage of software is what we call in the industry as the "OEM Licence", otherwise known as "came with the computer" license, and customers are often left without a re-install cd should something happen (like virus infection or hard disk crash).
After numerous customer complaints, Microsoft is now allowing people to donwload a personal backup copy of Microsoft Office.
Due to the popularity of our website we are getting many phone calls for small and hard to find computer parts.
Sorry, the parts we stock are for use of our technicians only. They are not for sale.
For example: • HP P3005 Gear Kit -- P30005-GK --RU5-0958-000CN • HP P3005 Gear Kit -- P30005-GK --RU5-0956-000CN
These parts cost less than a buck. If you want to hire us to diagnose your problem or to install the part, we welcome your call, but selling parts is not profitable for us and we are not setup for it.
Viewed 604 Times
Date Blogged: 12/11/2009
Software Update Breaking Sonys
In the last couple of days, we have seen a number of Sony VIAO notebooks coming in with Blue Screen of Death (for XP) or Black Screen of Death (for Vista).
All of them have the same problem. A recently installed software update.
Strangely, it has been different softwares for different machines. For two of them, it was the Microsoft update. On one of them it was Office Update, and for two others, application (like Adobe or HP) updates.
Obviously, some low level hardware driver or dll has an incorrect version causing all this trouble.
In a twisted way, our recommended solution is one of prevention, which is to apply all the software updates in time.
Viewed 608 Times
Date Blogged: 12/7/2009
Windows 7 Upgrade Chart
We had our taste of Windows 7 Install/Upgrade/Migrate today when we moved a customer's data from Windows XP Home to WIndows 7 Professional.
The entire process took about six hours and cost the customer $255 (he had 50GB of email, documents and music). It was not without pain.
Believe it or not, there are 64 different ways to move to Windows 7 (see the chart below). We recommend that unless you are falling in a green box, please call us to perform the migration for you.
Viewed 831 Times
Date Blogged: 10/30/2009
How to Cancel Paypal Subscription
You know how easy it is to click on a Paypal "Subscribe Now" button and signup for products and services. They are everywhere. But wait till you discover how difficult it is to cancel that subscription.
Nobody wants to make it easy for you to quit. We call it "I want to quit the gym or Maria" (clip shown below) tactic.
Even PayPal doesn't make it any easy. Please follow these elaborate steps (you might want to print this page for handy reference). Even finding the right item in the "come-and-go" cascading menus is a challenge.
A number of customers are calling in about a "weird Google problem" that is taking them to a website called Upsalepont.com.
This is a NOT a problem with Google, but a spyware on the user's machine.
If you are our customer, please run a full scan of F-Secure on the infected hard drive.
If you do not have F-Secure installed on your machine, you can try installing MalwareBytes or SuperAntiSpyware and try to clean it that way. Depending on the extent of damage, this might not work, and you may have to bring in the machine to our shop for removal.
Viewed 1483 Times
Date Blogged: 6/26/2009
Notebook Hard Drives
While cleaning we found the following working 2.5 inch hard drives. If you are attempting data recovery, or need identical drives, please contact us at (205)251-5966
List of Hard Drives • Toshiba, P/N 318052-001, MK4025GAS • Toshiba, MK6014MAP, 6GB • Hitachi, N155, 30GB • IBM, N79, 10.06GB • Hitachi, N155, 40GB SOLD • IBM, IBM-H2344-A4, 344MB • Hitachi, DK221A-34, 340MB • Fujitsu, MHC2040AT, 4GB
Viewed 1520 Times
Date Blogged: 6/17/2009
Desktop Hard Drives
While cleaning we found the following working hard drives.
If you are attempting data recovery, or need identical drives, please contact us at (205)251-5966
