How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server

-
happiness is being able to move/copy a database even when backup/restore and the Copy Database Wizard (cdw.exe) which is *cough* crap *cough* error out....

Straight from the horses mouth...or in this case, the MS KB.

link

Popular posts from this blog

Best Replacement for Missing Start Menu in Windows 8 & 8.1

-
Windows 8 took away something useful we've been using since the mid 1990's (in Windows 95 & NT 4).  In unrelated news , Steve Ballmer has been fired .  But still--we have to live with the abomination which is Windows 8.  If you have a touch screen, it's somewhat usable.  But if you just have a pointing device, i.e. mouse, touchpad, pointing stick, etc.; tough. This is crap. The Windows 8.1 upgrade/update/patch/lipstick-on-a-pig gives us back a start button without the start menu (more crap), and the option to boot to the desktop, rather than the Metro interface or whatever they're calling it this week.  Crap-crap-crap. Yours truly has been using and customizing the Start Menu for years.  The classic Start Menu (an option in XP & Vista, but taken away in Windows 7) allowed quick access to additional icons, e.g. a new shortcut on the classic start menu in XP named "Word" meant two keystrokes opened Word--tapping the Windows key (on a 'Win
Read more

Windows Update 0x8024D001 fixed

-
Unbelievable . A Google search for this returns lots of hits, however the variety of solutions seem to have mixed results. This happened to me most recently in a shiny new Windows XP SP3 Pro virtual machine in VMware Workstation 9.x.  The only item installed was, as many might expect, VMware tools. I am a fan of stopping the windows update service, deleting the c:\windows\softwareupdates folder, and then starting the windows update service.  Does that fix this?  Of course not.  (Actually, my usual screw-up is the clock being horribly off....) I installed Chrome and MBSA 2.2.  MBSA threw an error.  Chrome worked like a charm. Ultimately this forum , this KB article , and THIS DOWNLOAD FIXED IT .  Many reboots. Yes, XP is going EOL very soon. You know what, that Mac Airbook with the ridiculously short screen (both models) is starting to look pretty good.  (I really miss those 4:3 monitors.  Stinking display manufacturers...). This VM was originally plagued with getting a
Read more

Endless Loop: whoa google chrome has crashed relaunch now?

-
This reminds me why I switched to Firefox in the first place years ago.  Oi. Isn't it lame when a Google search for what appears to be a commonly-experienced problem does not have a solution which readily presents itself? A search for "whoa google chrome has crashed loop" (or etc.) brings up a variety of results in the Google Product Forums--and kudos to all the good people that took the time to post, and repost, and follow-up, and try to help & collaborate.  Regrettably, I couldn't find something that worked for me. This page says to visit this page , and if that doesn't work... create a new user profile .  Wait, what?  Create a new Windows user profile?  Madness!  Mercifully no, the page is titled "Create a new browser user profile".  Sheesh. While searching to see if Chrome writes a log someplace, one nice person's article ultimately led me to stumble across the solution. Here's what I found that works.  Obvious disclaimer: us
Read more