sqlserver数据库恢复后修复用户的过程

发布时间：2020-12-12 14:14:45 所属栏目：MsSql教程来源：网络整理

导读：USE [test] GO /****** Object: ?StoredProcedure [PROJECT].[autofix_user] ? ?Script Date: 12/06/2012 15:25:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: zhaorb -- Crea

USE [test] GO /****** Object: ?StoredProcedure [PROJECT].[autofix_user] ? ?Script Date: 12/06/2012 15:25:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <zhaorb> -- Create date: <Create Date,> -- Description: <Description,> -- ============================================= ALTER PROCEDURE [PROJECT].[autofix_user] AS DECLARE @cur1 CURSOR DECLARE @name varchar(64)? DECLARE @sid varchar(64) SET @cur1=CURSOR FOR ?select UserName = name,UserSID = sid from sysusers ? ? ? ? ? ? where issqluser = 1? ? ? ? ? ? ? and ? (sid is not null and sid <> 0x0) ? ? ? ? ? ? and ? (len(sid) <= 16) ? ? ? ? ? ? and ? suser_sname(sid) is null ? ? ? ? ? ? order by name OPEN @cur1 FETCH NEXT FROM @cur1 INTO @name,@sid WHILE(@@FETCH_STATUS=0) BEGIN EXEC sp_change_users_login 'AUTO_FIX',@name print 'fixed'+@name FETCH NEXT FROM @cur1 INTO @name,@sid END CLOSE @cur1 DEALLOCATE @cur1

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!