Tuesday, November 30, 2010

SQL Orphaned Users

This is well-documented but for some reason I can never remember the name of the procedure used to fix "orphaned" users in SQL server.

The name is sp_change_users_login.

Usually, you want to do this: sp_change_users_login 'Auto_Fix', 'login_here'

More information can be found here

Monday, November 1, 2010

Word, Excel files very slow to open on XP

This has happened to me twice in the last few months:

I experience a 2-3 minute delay after double-clicking on a Word or Excel document in Windows Explorer before the file is opened.

After an hour or so of Googling, it appears that the problem is fairly common and that there may be several very different causes. This posting is my attempt to deal with this on my computer. You may or may not have the same problem.

I'm running XP, but I think the problem spans all Windows versions since NT (Vista, Window 7, too).

Most articles (especially from Microsoft) talk about problems with inaccessible network locations or locations with lots of files. Here's one such example: http://support.microsoft.com/kb/818792. In my case, this wasn't the issue. Disconnecting all network favorites and network drives made not difference at all.

For me, it turns out that DDE doesn't work properly and that the best fix was to stop using.

Windows Explorer can take actions based on the file extention. These can be configured in Windows Explorer under the Tools -> Folder Options dialog. The fix was to stop using DDE and launch Word or Excel directly.

To do this

  1. Open Windows Explorer, click Tools, Folder Options.
  2. Select the "File Types" tab.
  3. Locate the offending file extension. (In my case, it was doc, docx, xls, xlsx). Select it.
  4. Click on the Advanced button.
  5. Click on the Open Action, and press Edit

  6. Go to the end of the "Application used to perform this action" line

  7. Add "%1" to the end (include the quotes).

  8. Uncheck the "Use DDE" checkbox.

This launches the application directly instead of using DDE.

For me, some unanswered questions persist:

  1. Is DDE broken on my computer?
  2. If so, what broke it?
  3. I fixed this about a month ago. Why am I having to do it again?
  4. Are there other side effects?