freealf.com

Fixing Login->User Associations in SQL Server

This post is for me.  It's about something I am always forgetting.

In Microsoft SQL Server, a database server has logins and each database has users.  Every user is associated to one login.  If you detach a database from one server and move it to another (or, equivalently, backup and restore to a different machine) then your user is no longer associated to a valid login.  This happens even if you have a login on the new machine with the same name as on the old machine.

Effect?  No access.

It's easy to fix, though.  As sa, run this stored procedure in the affected database:

SP_CHANGE_USERS_LOGIN UPDATE_ONE, 'username', 'login_name'

Advertising People Need to Think

So I'm stumbling home from the bar tonight.  It's about 4am, and the not-so-major street I'm wandering down is deserted.  And who do I run into?  David Suzuki.

He's staring at me from across the street, ten feet tall and lit with floodlights.  Yes, he's a billboard.  Not just the normal, tacky kind, but the extra-tacky rotating three-ads-in-one-spot kind.

What's he doing?

Holding up a compact fluorescent lightbulb and telling me that I have the power to save energy.  From his 10,000 Watt rotating big ass billboard in the middle of nowhere.

Where does he get off?

Surfaced

This is intended as a quick update for those who follow this blog (ie: have it in their RSS reader) for their own amusement.  I have just surfaced from the Great Busy Period and have started to have a bit of a life again.  The past few months have been totally consumed by my Literature Review at JCU and building and launching the SonyRewards website at work.

Both are now done!

Current projects:

• Setting up my new MacBook Pro - this thing is soooo cool.  TextMate is an awesome editor.  Recommendations for Mac software are most welcome.
• Virtual Worlds for Astronomy Collaboration - experimenting with a few colleagues on using a 3D interactive environment for astronomy simulation and education.  This is potentially very interesting, but it's really just in its infancy.
• Learning solid basic photography.
• Learning a bit of SmallTalk (well, Squeak, actually)
• Learning a bit of Windows PowerShell

Feel free to say "hi"...  I'm back in the world!