Thread: MS SQL help?
View Single Post
Head416 Head416 is offline
Registered
 
Head416's Avatar
 
Join Date: Oct 2006
Location: Los Angeles, CA
Posts: 1,881
Garage
Sorry, that linked has some good info, but this is what you should lookup:

sp_change_users_login 'Auto_Fix', 'user'

That should fix an orphaned account with the login ID in place of 'user'.
Old 08-13-2013, 04:15 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #13 (permalink)