Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > sqlserver数据库迁移后,孤立账号解决办法

sqlserver数据库迁移后,孤立账号解决办法

WBOY
Release： 2016-06-07 18:02:51
Original
811 people have browsed it

sqlserver数据库迁移后,孤立账号解决办法,需要的朋友可以参考下。

代码如下:
declare @cmd nvarchar(4000)

set @cmd = N'exec [?].sys.sp_change_users_login @Action = ''Auto_Fix''
, @UserNamePattern = ''qa''
, @LoginName = null
, @Password = ''abc'' '

exec sp_msforeachdb @cmd

Related labels：
孤立账号
source：php.cn
Previous article：记一次成功的sql注入入侵检测附带sql性能优化 Next article：sqlserver中在指定数据库的所有表的所有列中搜索给定的值
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
"waitForSelector" times out before the element becomes visible, even though the element is on screen I'm building a checkout bot but I'm having trouble with those stupid "enter your phon...
From 2024-04-04 18:31:08
0
1
1416
How to select, match and return values ​​in mysql query? I have two tables, the transfer table and the clubs table. This is the table transfer: id ...
From 2024-04-02 17:18:57
0
1
380
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template