SQL cannot take the action auto_fix due to duplicate SID

November 3rd, 2014

I ran into an unusual Error in SQL “Msg 15331, Level 11, State 1″ “cannot take the action auto_fix due to duplicate SID”. I had restored a database from another server and decided to update the database owner name to one that had a mismatched SID.

Here is how to find it:

SELECT u.name, u.sid, sp.name, sp.sid
FROM sys.sysusers u
LEFT JOIN sys.server_principals sp
ON u.name = sp.name
WHERE u.sid != sp.sid

So at first I tried to fix it myself by updating that SID and found:
Msg 259, Level 16, State 1, Line 1
Ad hoc updates to system catalogs are not allowed.

The SID for the owner would not repair until I changed the owner of the database to “sa” or myself. (go to db properties, select files, change owner value.) Once this was updated the autofix statement will repair the user: EXEC sp_change_users_login ‘Auto_Fix’, ‘username’

At that point I could set the db owner back to the desired name.

Computers

This day be pirate!

August 8th, 2014

seekye

landship

Pirate weekend starts today in Bisbee. I had to upgrade the van to a landship. (While I wait for the funds to build a real landship.) Does adding a mast and some paint count? The text in the back says “Seek Ye First.” I know the font is small but I had a stencil made and it’s not ready in time. The graphic is how I reconcile Godliness with Pirate theme. Go straight to the cross!

http://www.facebook.com/BisbeePirates

Pointless

It’s a Keyboard Keyboard.

July 30th, 2014

Where else should you put your keys than a keyboard keyboard? Of course it should light up, connect to USB and be Starcraft 2 branded. I put an outlet in the wall with USB connectors as well as standard plugs. The keys clip onto stainless steel drawer handles. Only one of the electrical paths was damaged by drilling the holes for bolts. I tested it each time I drilled one out. The lower left corner of the key backlights no longer have an LED. Everything else works! Now the family fights: Is it a keyboard keyboard©, or is it a key keyboard©?

A keyboard keyboard

Computers

Finding an SQL Job that shows an error in logs

May 27th, 2014

I was perusing the MSSQL Agent logs and came across a job that kept printing errors every 20 seconds. It has an id with a long number. How can you find what job this is by name?
Here is what the error looks like: “Request to run job 0x17DF82795C5C224CBF7DC88E8E3C4E12 (from Alert 2618) refused because the job is not currently enabled.”
To find the job I must assume that this mess of numbers is a GUID, and therefore it relates to a name?
use msdb
go
select * from dbo.sysjobs

I find a job_id that relates to the problem above by just grabbing the last part of the guid without dashes. Here is the real job_id:
“7982DF17-5C5C-4C22-BF7D-C88E8E3C4E12″

I can also look for when this job might fire again:
select top 100 * from sysjobschedules where job_id like ‘%C88E8E3C4E12%’

The job is disabled and there are no schedules for it. So why is it erroring every 20 seconds? It is an alert:

select * from dbo.sysalerts where id = 2618

Someone created a check for blocking transaction job, and fired it upon Blocking Alert. Then they found out that they didn’t want the thousands of emails so they disabled the job. The alert is enabled, calling a disabled job. Error logs get filled now instead of inboxes. The solution was to disable the alert.

Computers, Work

Astonishing new Information Society track!

March 11th, 2014

Mortgage Burnt. Success!

October 14th, 2013

The mortgage is burnt thanks to God’s prompting and providence. (And for pointing to Dave Ramsey) Everyone’s fellowship was a huge blessing and refreshed our spirits. Thanks to everyone who rejoiced with us! Attached is what we played with after everyone ran off. Laser beams and long exposures. You can tell its me by the chin in the profile.


lasers

Uncategorized

Finally someone understands TEA!

March 8th, 2013


This guy almost likes tea as much as I.

Uncategorized

Ethiopian Food in Little Ethiopia

July 29th, 2012

Arizona is one of the few states blessed with Ethiopian Food.  Zemam’s in Tucson is best of class!  They have high standards of cleanliness in a slightly run-down building.  Also the tiny but amazing Babylon market gets the surplus Injera from Zemam’s so we can grab some and make our own meal!  Phoenix has a couple that are not impressive, Lallibella is a vegetarian place with more traditional decor.  Below is the Ethiopian Alphabet.  Seems way too complicated for the amount of words in the language.

Ethiopian Alphabet on skin.

We were also blessed with the opportunity to visit Little Ethiopia in Los Angeles.  Like Little Tokyo and other cultural minority areas, Little Ethiopia seems to be drying up and moving away.  There were basically a handful of stores on one street about a city block long.  We got lentils and Injera from each one as a sample. Here are our findings compared to Zemam’s:

 

Location Impression
Messab Second Hand Smoke permeated the room. Lentils at 9.50 were not edible. Injera was bland.
Rahel Veggie Injera was way too sour. Lentils at 10.70 were more of a soup, not pleasant.
Nyala Tried Kik Wat and split peas. They were watered with potato and had bland Injera. Lentils were 11.00
Little Ethiopia Injera lacked a sour edge. Dark but not overcooked, possibly better Teff used? The lentils were good, and had spice. Garbanzos were undercooked and the chicken not edible. Doro 12 dollars, Kik 5.00
Rosalind’s Injera was better than the others. Undercooked collards and the lentils tasted weak, but acceptable. Chickpeas were too oily. We tried a veggie sampler. The meatballs were scary. Overcharged Dinner prices at Lunch time.

Restaurant

Best No-bake cookies yet.

May 20th, 2012

Easy Chocolate No-Bake Oatmeal Cookies

2 Cups Sugar

1/2 Cup Milk

1/4 Cup Butter

2 Tablespoons Cocoa Powder

1/4 Bar of Scharfenberger Chocolate with Nibs

Dash salt.

COMBINE all above and bring to a boil for one minute stirring constantly (the goal is no granulated sugar but not burnt tasting).

Remove from heat and stir in:

1/3 cup natural smooth peanut butter

1 Tsp vanilla

1 Tbsp orange juice

3 Cups natural quick oats.

Quickly plop spoonfulls onto parchment paper and let them cool completely.  The faster you do this the more glossy ones you get!  Don’t judge by calories or appearance. They Heaven.

Pointless, Restaurant

Torchlight 2 in BETA!

May 19th, 2012

We have been playing Mythos for months now so I am getting a bit burnt out.  The Diablo 3 release comes and all the Mythos players vanish.  Coincidence?  I think not.

Now Torchlight 2 is going into beta this weekend starting 5-18-2012.  I haz me some Keee!  Woo!

Gaming