sqlserver数据库迁移后,孤立账号解决办法
- WBOYOriginal
- 2016-06-07 18:02:51789browse
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
Statement：
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
Previous article：记一次成功的sql注入入侵检测附带sql性能优化Next article：sqlserver中在指定数据库的所有表的所有列中搜索给定的值