Fixing broken users after Database Restore

Ever restored a Database which was created on a different server then not been able to use the same logon you had previously set up?

This command fixes the problem with the account.

-- Replace username with the account to fix
sp_change_users_login 'Auto_Fix','username'

Author Paul Hayman

Paul is the COO of kwiboo ltd and has more than 20 years IT consultancy experience. He has consulted for a number of blue chip companies and has been exposed to the folowing sectors: Utilities, Telecommunications, Insurance, Media, Investment Banking, Leisure, Legal, CRM, Pharmaceuticals, Interactive Gaming, Mobile Communications, Online Services.

Paul is the COO and co-founder of kwiboo (http://www.kwiboo.com/) and is also the creator of GeekZilla.

Comments

Simone said:

I've been using this command since 5 years... and I always forget the syntax

26/Jun/2007 04:15 AM

phayman said:

Me too.. that's why I documented it somewhere I could find it quickly

26/Jun/2007 09:30 AM

jrobiii said:

Heheh! Same here. Google is your friend!

03/Feb/2010 13:22 PM

Sara said:

Fantastic!!! Very Very usefull!

11/Jul/2010 18:30 PM

Mathias said:

thanks man, you just saved my day.

Been sitting here for 9 hours restoring databases, this was the last piece missing. I was banging my head cause I thought my backups are no good.

Thanks for the good work!!

14/Mar/2011 01:44 AM

GeekZilla