Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Security

sp_change_users_login

Is there a function like sp_change_users_login that will work with Windows NT Accounts?
[88 byte] By [TWA] at [2007-12-20]
«« Creating zip files without Path info
»» New to Visual Studio 2005 and printing
# 1

No, there is no such function, because there is little need for it. If you recreate the Windows logins, they will automatically be mapped correctly to the corresponding database users. For recreating the Windows logins, you could look into sp_help_revlogin (http://support.microsoft.com/kb/246133/, http://blogs.msdn.com/lcris/archive/2006/04/03/567680.aspx)

What is the exact scenario you are trying to address?

Thanks
Laurentiu

LaurentiuCristofor at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Security...
SQL Server
SQL Server Security

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified