Differences

This shows you the differences between two versions of the page.

--- microsoft-sql-server-user-einem-login-zuordnen [2017/08/21 19:06] – created baumi
+++ microsoft-sql-server-user-einem-login-zuordnen [2017/09/08 15:02] (current) – [Neue Version:] baumi
@@ Line 1: / Line 1: @@
 ~~META:
-date created = 2012-11-12
+date created = 2012-11-12 07:35
-&date modified = 2012-11-12
+&date modified = 2012-11-12 07:35
 ~~
 ====== Microsoft SQL Server – User einem Login zuordnen ======
+===== Alte Version – wird mit SQL Server 2012 noch unterstützt: =====
-{{tag>kb microsoft sql-server}}
+<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}}