Wither you are part of the Mormon faith or not there is a good chance that you know the name Gordon B. Hinckley.  His passing is sad for many of us.  He has been the prophet for 13 years and has been in the first presidency since 1981.  For many who are younger or new converts he was the only prophet they have known.  His wisdom, character, humor, courage, and capacity to express love toward all were some of his trademark attributes.  He has been known as the face of the Church of Jesus Christ of Latter-day Saints (LDS Church) for seven decades. 

 

I remember when President Hinckley became the prophet.  I remember the feeling that "ahh, we have a 'dream team' and we're going to see the Church move faster than it has before".  I also remember at that Stake Conference we were asked to sustain him as our new prophet.  I got an overwhelming feeling that I knew he was supposed to be the prophet and that I needed to follow his council. 

 

I have always felt a special bond with President Hinckley.  We both served our missions in England; both with about as much success.  It was very uplifting for me to know that even he got discouraged while serving and wondered if his time there was well spent.  I spent two years teaching people the gospel of Jesus Christ day-in and day-out.  Eleven hours a day 6 and 1/2 days a week I searched for people looking for truth and light.  I taught hundreds but I baptized a single person on my mission.  I know that you can not measure the success of a mission by baptisms -- I do not know how to measure such a thing; But I do know that it was worth the time I spent and hearing of his experiences gives me even more confidence that my service was valuable. 

 

I know that I am not alone in thinking that his combine contributions to the Church and to humanity in general were very, very great! 

 

We prayed for him daily and we were blessed that he could stay with us as long as he did.  He is our beloved prophet.  And while I will miss him deeply this is an exciting time as we get to sustain a new prophet.  While it is not easy to feel right now that same confirming spirit I felt when President Hinckley became the Prophet will again testify to us that a new prophet is hear to lead us in this next era of faith.

 

President Hinckley, we love you!  God be with you 'til we meet again.

 

--Nathan Zaugg

I posted a blog entry a while back about how to change the owner of a database.  What that still does not solve is the problem you have when there is a database user in the database you restored and there is a database user already in your system, each with the same name.  While it seems intuitive that it should just work, it doesn't!  The user in the database is essentially an orphan.

 

To find such orphans in your newly-restored database we run this command:

This simply gives us a list of these orphan logins.  Generally you want to map the two users back to each other and we can do that with this command:

You can run the first command again to see if it worked.  In my case I had to try to login a couple of times before the I could get it to login.  If that fails to work there is another, more powerful command you can run:

If you are too lazy to even do that, there are a few stored procedures on this blog entry that you can try running:

 

I hope this helps someone besides just me!  Drop me a line if this blog entry was useful.

 

--Nathan Zaugg