title: Updating SQL Server 2008 LOGIN SID
body: <p>If an Active Directory SID doesn't match the 
   <code>SQL Server 2008</code>
   Login SID (<code>sys.server_principal</code>) there doesn’t appear to be a way to ALTER/UPDATE that value.  <code>ALTER USER</code> will allow you to remap a USER to a LOGIN, but <code>ALTER LOGIN</code> will not allow you to remap a LOGIN to Active Directory so to my question…</p>
  
  <p>Is there any way, documented or otherwise, to update the LOGIN SID with the AD SID besides dropping and recreating the login?  I am using <code>OPENROWSET</code> to get the AD SID value, but I can't find a way to update the LOGIN SID (mostly because I don't think it can be done)</p>
  
  <p>By the way, I am aware that ad-hoc queries to the system tables are not allowed (because I tried that already).</p>