<body >

Gurzbagsome

Friday, April 22, 2005

I had a dream and you were in it.
The length of your snout was infinite.
You had become gurzbagsome,
Which was just what I'd expected!
- to the tune of I Don't Believe You by The Magnetic Fields

Labels: ,

Permalink

If I had a thousand biscuits

Thursday, April 21, 2005

by Tom Jones

If I had a thousand biscuits
Toss them all your way, I'd do
If I had a hundred hamsters
I would stuff them in your flue
If I had a dozen weasels
I would hide them in your loo
If I knew a single menace
Well, by jove, that would be you

Labels: ,

Permalink

Orphaned Logins



When you transfer SQL Server logins to a new server with DTS or create them on the new server manually, the SIDs don't match up with the server that you are importing your database backups from. To avoid this, Microsoft has created handy scripts (for transferring from 2000 to 2005, for transferring between 2005 instances). If you've already botched it up, you can find the orphaned logins like so:

EXEC sp_change_users_login 'Report'

And you can fix them one at a time like so:

EXEC sp_change_users_login 'Update_One', 'username', 'login'

which links users in databases with the username "username" to SQL Server logins with the name "login".

Labels:

Permalink

Shrimp Tempura

Wednesday, April 6, 2005

You draw me without fail
with your battered crispy tail!
I'd trudge through wind and hail
And brave the strongest gale!

Labels: ,

Permalink

 
   



Blogger Template by Gecko & Fly, modified by yours truly.