My Directory Opus 8.1 evaluation license expired today and I regret that I will not be purchasing it. I just found the performance to be unacceptable.  I love all the features but it's just too slow.

Back in the old days on the Commodore Amiga, dopus where it was at!!! :)

Do you remember Pat from Saturday night live?  Well it turns out Pat, or Julia Sweeney as her name really is, is full of surprises.  I was listening to NPR/PRI’s This American Life just by coincidence one day and ran into the most unusual broadcast called “Godless America”.  Normally I try to avoid the this topic like the plague, but I have to give Julia a plug here as I was quite entertained and moved by her “Letting Go of God” dialog.

Unfortunately I missed her play in Los Angeles… well actually it’s unfortunate that it was only in Los Angeles, as I am not.  She is working on a CD version of the play and you can hear an excerpt here as the 2nd half hour of the This American Life broadcast.

I'm not sure when this started but I noticed that my Exchange Server's POP3 and IMAP4 services were no longer being started. When I would manually start them I would get 'Error 1083: The executable program that this service is configured to run in does not implement the service.'

I found the Q277770 Microsoft Knowledge base article which addresses this and fixed the problem. However I still do not know what caused this as it was working at some point in the past.

I downloaded the latest dasblog source code, compiled it, and upgraded my version. Let's just hope I copied over the correct files... nothing more, nothing less.

I can’t tell you how many times I’ve done an import and ended up with the wrong database owner.  Use this following script to change the owner on all tables in a database.

In the sql below, set the @oldowner and @newowner variables appropriately.

DECLARE @oldowner sysname, @newowner sysname, @sql varchar(1000)

SELECT
  @oldowner = 'OLD_OWNER',
  @newowner = 'dbo',
  @sql = '
  IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES
  WHERE
      QUOTENAME(TABLE_SCHEMA)+''.''+QUOTENAME(TABLE_NAME) = ''?''
      AND TABLE_SCHEMA = ''' + @oldowner + '''
  )
  EXECUTE sp_changeobjectowner ''?'', ''' + @newowner + ''''

EXECUTE sp_MSforeachtable @sql

(I found this somewhere on the internet some time ago but have lost it's reference.)