~~META:
date created = 2012-11-12 07:35
&date modified = 2012-11-12 07:35
~~
====== Microsoft SQL Server – User einem Login zuordnen ======
===== Alte Version – wird mit SQL Server 2012 noch unterstützt: =====
<code sql>
USE [dbname];
GO
EXEC sp_change_users_login 'Update_One' 'dbuser' 'login';
GO
</code>
[[http://msdn.microsoft.com/en-us/library/ms174378.aspx]]
===== Neue Version: =====
<code sql>
USE [dbname];
GO
ALTER USER dbuser WITH LOGIN = login;
GO
</code>
[[http://msdn.microsoft.com/en-us/library/ms176060.aspx]]
{{tag>kb windows sql-server}}