第一〇八九章 反击开始 (4 / 10)
        --CreatetheTargetServersrole(forusebytargetserverswhendownloadingjobs/uploadingstatus)

        IF(EXISTS(SELECT*

        FROMmsdb.dbo.sysusers

        WHERE(name=N'TargetServersRole')

        AND(issqlrole=1)))

        BEGIN

        --Iftherearenomembersintherole,thendropandre-createit

        IF((SELECTCOUNT(*)

        FROMmsdb.dbo.sysuserssu,

        msdb.dbo.sysmemberssm

        WHERE(su.uid=sm.groupuid)

        AND(su.name=N'TargetServersRole')

        AND(su.issqlrole=1))=0)

        BEGIN

        内容未完，下一页继续阅读

更多完整内容阅读登陆

《墨缘文学网，https://wap.mywenxue.org》