SQL ????? ?? ???????? ?? ??? ????? ???? ?? ??????? ??????????? ???? ?? ??? ???? ????

???? ?????? ???? ??????
???? ID: 246133 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

??? ????? ?? ??? ??????? ??, ?? ??? ?????????? ???? ???? ?? ?????? ?? ????? ??? ?? ???? ?? ???? ???? ????, ?? ????? ?????? ????? ??????? ???? ??:
????? 18456, ???? 16, ????? 1
'% Ls' ?? ?????????? ?? ??? ??? ?? ???? ????
???? ????? ???? ?? ??????? ?? ????? ?? ??????????? ???? ????? ?? ???? ????? ???? ?? ?? ???? ?? ?????????? ????? ???? ?? ??????? ???? ?? ????? ?? ????

SQL Server 7.0 ?? ??? ????? ?? ??? ????? ???? ?? ??????? ??????????? ???? ?? ??? ???? ????

SQL Server 7.0 ???? ??????????????? ?????? (DTS) ???????? ?????????? ?????? ??????????? ????? ?? ???????????? ?? ?? ??????? ?? ??? ??, ????? ??? ?????????? SQL Server ????? ???? ?? ??? ??????? ??????????? ???? ??? SQL Server 7.0 SQL Server 7.0 ?? ??? ?? ?? ???? ???? ????? ?? ?? ??? ?? ?? ???? ????? ?? ????? ???? ?? ??????? ???????????, "??? ????? ??????????? ?????????? ????? ?? SQL ????? ?? ???? ????????? ?? ??? ??????? ?? ???" ??? ??? ??? ????? ?? ???? ?????

SQL ?? ????? ???? ?? ??????? ??????????? ???? ?? ??? ???? Server 7.0 SQL Server 2000 ?? SQL Server 2000 ??? ??? ??? ?? ????? ?? ???

??????????? ???? ?? ??? ????? ???? ?? ??????? ???? SQL Server 7.0 ????? ?? ?? ??????? ?? SQL Server 2000 ?? SQL Server 2000 ?? ?? ???????? ?? ???, ?? ??? DTS ????? ?????????? ????? ????? ?? SQL Server 2000 ??? ????? ?? ????? ??? ???? ?? ???, ????? ????? ?? ???? ????::
  1. SQL Server 2000 ?????? ????? ?? ?????? ???, ???? ??????????????? ?????? SQL Server ?????????? ??????? ??? ?? ????, ??????? ?? ??????? ????, ????-????? ??????????? ??????? ????-????? ????, ?? ???? ????? ?????.
  2. DTS ?? ????? ??????? ????? ??, ?? ??? ????? ?????????????? ????? ?????????? ????????????? ??.. ??????? ?? ???? ???? ?? ???? ????????,??????, ???????????? ??????? ?? ??? ??? ???

    ??????????SQL Server 2000 ?????? ????? ???? ????? SQL Server 2000 ?? 64-??? ??????? ??? SQL Server 2000 ?? 64-??? ??????? ?? ??? DTS ??? ?????? ???? ???? ??? ?? ?? ??? ???????? ?? SQL ????? ??????? ?? ???? ????? ???? ?? ??? ???, SQL ????? ?? ???? ??????? ????? ???? ????? ????? ?? ???? ???? ?? ??? ??? ????? ???? ?? ????????

    ???:??????? ????? ???? ??? SID DTS ???? ??????????? ???? ?????? ??? ??? SID ?? ????? ?? ???? ????? ???? ????? ??, ?? ??? ??? ????? ?? ?????????? ??????? ??????????? ?? ???, ?? ??????? ???????????? ?? ????? orphaned ?? ?????? ??? SID ??????????? ???? ?? orphaned ???????????? ?? ?????? ???? ???, "??? ????? ??????????? ?????????? ????? ?? SQL ????? ?? ???? ????????? ?? ??? ??????? ?? ???" ??? ??? ??? ????? ?? ???? ?????

SQL ????? 2005 ?? ???????????? ?? ??? ????? ???? ?? ??????? ??????????? ???? ?? ??? ???? ????

SQL ????? 2005 ?? ???????????? ?? ??? ????? ???? ?? ??????? ??????????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
918992SQL ????? 2005 ?? ???????????? ?? ??? ????? ???? ?? ??????? ??????????? ???? ?? ??? ???? ????

?? ????? SQL ????? ?? ???? ????????? ?? ??? ????? ???? ?? ??????? ??????????? ???? ?? ??? ??????

??? ???? ?? ???, ????? ??? ?? ???? ?? ???? ????:.
???
  • ????? ??????? ??? ????????? ?? ?? ???????? ???????????? ??? ??? ?? ?????sp_hexadecimal????????? ?? ???????? ??sp_help_revlogin????????? ?? ??? ???????? ?????????????????:.
  • ????????? SQL Server ?????? ???? ?? ?????? ???? ???? SQL ????? ?? ????????? ?? ??? ?? ???????? ?? ?????? ??? ???? ??? ?????? ???????? ?? ??? discouraged ???
  • ???? ??? ????? ?? ???? ??? ?????????? ??????? ?? ??? ?? ???? ?? ??? ??? remarks ?? ??????? ?????
  • ???? 2 ?? ????? ????? ????? ???? ???

?????? 1:

?? ???? ?????????? ???????? ?? ???? ???? ??:
  • ???? ????? ???? ?? ??????? ?? ??????????? SQL Server 7.0 SQL Server 7.0 ???? ?? ????
  • ???? ????? ???? ?? ??????? ?? ??????????? SQL Server 7.0 SQL Server 2000 ?? ????
  • You transfer logins and passwords between servers that are running SQL Server 2000.
To transfer logins and passwords between different versions of SQL Server, follow these steps:
  1. Run the following script on the source SQL Server. Continue to step 2 when you finish creating thesp_help_revloginstored procedure.
    ----- Begin Script, Create sp_help_revlogin procedure -----
    
    USE master
    GO
    IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL
      DROP PROCEDURE sp_hexadecimal
    GO
    CREATE PROCEDURE sp_hexadecimal
        @binvalue varbinary(256),
        @hexvalue varchar(256) OUTPUT
    AS
    DECLARE @charvalue varchar(256)
    DECLARE @i int
    DECLARE @length int
    DECLARE @hexstring char(16)
    SELECT @charvalue = '0x'
    SELECT @i = 1
    SELECT @length = DATALENGTH (@binvalue)
    SELECT @hexstring = '0123456789ABCDEF' 
    WHILE (@i <= @length) 
    BEGIN
      DECLARE @tempint int
      DECLARE @firstint int
      DECLARE @secondint int
      SELECT @tempint = CONVERT(int, SUBSTRING(@binvalue,@i,1))
      SELECT @firstint = FLOOR(@tempint/16)
      SELECT @secondint = @tempint - (@firstint*16)
      SELECT @charvalue = @charvalue +
        SUBSTRING(@hexstring, @firstint+1, 1) +
        SUBSTRING(@hexstring, @secondint+1, 1)
      SELECT @i = @i + 1
    END
    SELECT @hexvalue = @charvalue
    GO
    
    IF OBJECT_ID ('sp_help_revlogin') IS NOT NULL
      DROP PROCEDURE sp_help_revlogin 
    GO
    CREATE PROCEDURE sp_help_revlogin @login_name sysname = NULL AS
    DECLARE @name    sysname
    DECLARE @xstatus int
    DECLARE @binpwd  varbinary (256)
    DECLARE @txtpwd  sysname
    DECLARE @tmpstr  varchar (256)
    DECLARE @SID_varbinary varbinary(85)
    DECLARE @SID_string varchar(256)
    
    IF (@login_name IS NULL)
      DECLARE login_curs CURSOR FOR 
        SELECT sid, name, xstatus, password FROM master..sysxlogins 
        WHERE srvid IS NULL AND name <> 'sa'
    ELSE
      DECLARE login_curs CURSOR FOR 
        SELECT sid, name, xstatus, password FROM master..sysxlogins 
        WHERE srvid IS NULL AND name = @login_name
    OPEN login_curs 
    FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @xstatus, @binpwd
    IF (@@fetch_status = -1)
    BEGIN
      PRINT 'No login(s) found.'
      CLOSE login_curs 
      DEALLOCATE login_curs 
      RETURN -1
    END
    SET @tmpstr = '/* sp_help_revlogin script ' 
    PRINT @tmpstr
    SET @tmpstr = '** Generated ' 
      + CONVERT (varchar, GETDATE()) + ' on ' + @@SERVERNAME + ' */'
    PRINT @tmpstr
    PRINT ''
    PRINT 'DECLARE @pwd sysname'
    WHILE (@@fetch_status <> -1)
    BEGIN
      IF (@@fetch_status <> -2)
      BEGIN
        PRINT ''
        SET @tmpstr = '-- Login: ' + @name
        PRINT @tmpstr 
        IF (@xstatus & 4) = 4
        BEGIN -- NT authenticated account/group
          IF (@xstatus & 1) = 1
          BEGIN -- NT login is denied access
            SET @tmpstr = 'EXEC master..sp_denylogin ''' + @name + ''''
            PRINT @tmpstr 
          END
          ELSE BEGIN -- NT login has access
            SET @tmpstr = 'EXEC master..sp_grantlogin ''' + @name + ''''
            PRINT @tmpstr 
          END
        END
        ELSE BEGIN -- SQL Server authentication
          IF (@binpwd IS NOT NULL)
          BEGIN -- Non-null password
            EXEC sp_hexadecimal @binpwd, @txtpwd OUT
            IF (@xstatus & 2048) = 2048
              SET @tmpstr = 'SET @pwd = CONVERT (varchar(256), ' + @txtpwd + ')'
            ELSE
              SET @tmpstr = 'SET @pwd = CONVERT (varbinary(256), ' + @txtpwd + ')'
            PRINT @tmpstr
    	EXEC sp_hexadecimal @SID_varbinary,@SID_string OUT
            SET @tmpstr = 'EXEC master..sp_addlogin ''' + @name 
              + ''', @pwd, @sid = ' + @SID_string + ', @encryptopt = '
          END
          ELSE BEGIN 
            -- Null password
    	EXEC sp_hexadecimal @SID_varbinary,@SID_string OUT
            SET @tmpstr = 'EXEC master..sp_addlogin ''' + @name 
              + ''', NULL, @sid = ' + @SID_string + ', @encryptopt = '
          END
          IF (@xstatus & 2048) = 2048
            -- login upgraded from 6.5
            SET @tmpstr = @tmpstr + '''skip_encryption_old''' 
          ELSE 
            SET @tmpstr = @tmpstr + '''skip_encryption'''
          PRINT @tmpstr 
        END
      END
      FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @xstatus, @binpwd
      END
    CLOSE login_curs 
    DEALLOCATE login_curs 
    RETURN 0
    GO
     ----- End Script -----
    
    
  2. After you create thesp_help_revloginstored procedure, run thesp_help_revloginprocedure from Query Analyzer on the source server. Thesp_help_revloginstored procedure can be used on both SQL Server 7.0 and SQL Server 2000. The output of thesp_help_revlogin???????? ????????? ?? ??? SID ?? ??????? ?? ??? ????? ?? ??? ????? ????????? ??? ?????? ?? ?????? ?? ?? ??????? ?? ?????? ????? ?????? SQL ????? ?? ????????? ?????? ?? ???::
    EXEC master..sp_help_revlogin
    

???? 2

?? ???? ?????????? ???????? ?? ???? ???? ??:
  • ???? ????? ???? ?? ??????? ?? ??????????? SQL Server 7.0 SQL Server 2005 ???? ?? ????
  • ???? ????? ???? ?? ??????? ?? ??????????? SQL Server 2000 SQL Server 2005 ???? ?? ????
  • ???? ????? ???? ?? ??? ????? ????? ?????
SQL ????? ?? ???? ????????? ?? ??? ????? ???? ?? ??????? ??????????? ???? ?? ???? ??? ????? ????? ????? ????, ????? ????? ?? ???? ????:
  1. ?????????? ????????? ?? ????? SQL ????? ?? ??????
    USE master 
    GO 
    IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL 
    DROP PROCEDURE sp_hexadecimal 
    GO 
    CREATE PROCEDURE sp_hexadecimal 
    @binvalue varbinary(256), 
    @hexvalue varchar(256) OUTPUT 
    AS 
    DECLARE @charvalue varchar(256) 
    DECLARE @i int 
    DECLARE @length int 
    DECLARE @hexstring char(16) 
    SELECT @charvalue = '0x' 
    SELECT @i = 1 
    SELECT @length = DATALENGTH (@binvalue) 
    SELECT @hexstring = '0123456789ABCDEF' 
    WHILE (@i <= @length) 
    BEGIN 
    DECLARE @tempint int 
    DECLARE @firstint int 
    DECLARE @secondint int 
    SELECT @tempint = CONVERT(int, SUBSTRING(@binvalue,@i,1)) 
    SELECT @firstint = FLOOR(@tempint/16) 
    SELECT @secondint = @tempint - (@firstint*16) 
    SELECT @charvalue = @charvalue + 
    SUBSTRING(@hexstring, @firstint+1, 1) + 
    SUBSTRING(@hexstring, @secondint+1, 1) 
    SELECT @i = @i + 1 
    END 
    SELECT @hexvalue = @charvalue 
    GO 
    
    IF OBJECT_ID ('sp_help_revlogin_2000_to_2005') IS NOT NULL 
    DROP PROCEDURE sp_help_revlogin_2000_to_2005 
    GO 
    CREATE PROCEDURE sp_help_revlogin_2000_to_2005 
    
    @login_name sysname = NULL, 
    @include_db bit = 0, 
    @include_role bit = 0 
    
    AS 
    DECLARE @name sysname 
    DECLARE @xstatus int 
    DECLARE @binpwd varbinary (256) 
    DECLARE @dfltdb varchar (256) 
    DECLARE @txtpwd sysname 
    DECLARE @tmpstr varchar (256) 
    DECLARE @SID_varbinary varbinary(85) 
    DECLARE @SID_string varchar(256) 
    
    IF (@login_name IS NULL) 
    DECLARE login_curs CURSOR STATIC FOR 
    SELECT sid, [name], xstatus, password, isnull(db_name(dbid), 'master') 
    FROM master.dbo.sysxlogins 
    WHERE srvid IS NULL AND 
    [name] <> 'sa' 
    ELSE 
    DECLARE login_curs CURSOR FOR 
    SELECT sid, [name], xstatus, password, isnull(db_name(dbid), 'master') 
    FROM master.dbo.sysxlogins 
    WHERE srvid IS NULL AND 
    [name] = @login_name 
    
    OPEN login_curs 
    
    FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @xstatus, @binpwd, @dfltdb 
    
    IF (@@fetch_status = -1) 
    BEGIN 
    PRINT 'No login(s) found.' 
    CLOSE login_curs 
    DEALLOCATE login_curs 
    RETURN -1 
    END 
    
    SET @tmpstr = '/* sp_help_revlogin script ' 
    PRINT @tmpstr 
    SET @tmpstr = '** Generated ' 
    + CONVERT (varchar, GETDATE()) + ' on ' + @@SERVERNAME + ' */' 
    PRINT @tmpstr 
    PRINT '' 
    PRINT '' 
    PRINT '' 
    PRINT '/***** CREATE LOGINS *****/' 
    
    WHILE @@fetch_status = 0 
    BEGIN 
    PRINT '' 
    SET @tmpstr = '-- Login: ' + @name 
    PRINT @tmpstr 
    
    IF (@xstatus & 4) = 4 
    BEGIN -- NT authenticated account/group 
    IF (@xstatus & 1) = 1 
    BEGIN -- NT login is denied access 
    SET @tmpstr = '' --'EXEC master..sp_denylogin ''' + @name + '''' 
    PRINT @tmpstr 
    END 
    ELSE 
    BEGIN -- NT login has access 
    SET @tmpstr = 'IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE [name] = ''' + @name + ''')' 
    PRINT @tmpstr 
    SET @tmpstr = CHAR(9) + 'CREATE LOGIN [' + @name + '] FROM WINDOWS' 
    PRINT @tmpstr 
    END 
    END 
    ELSE 
    BEGIN -- SQL Server authentication 
    EXEC sp_hexadecimal @SID_varbinary, @SID_string OUT 
    
    IF (@binpwd IS NOT NULL) 
    BEGIN -- Non-null password 
    EXEC sp_hexadecimal @binpwd, @txtpwd OUT 
    SET @tmpstr = 'CREATE LOGIN [' + @name + '] WITH PASSWORD=' + @txtpwd + ' HASHED' 
    END 
    ELSE 
    BEGIN -- Null password 
    SET @tmpstr = 'CREATE LOGIN [' + @name + '] WITH PASSWORD=''''' 
    END 
    
    SET @tmpstr = @tmpstr + ', CHECK_POLICY=OFF, SID=' + @SID_string 
    PRINT @tmpstr 
    END 
    
    FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @xstatus, @binpwd, @dfltdb 
    END 
    
    IF @include_db = 1 
    BEGIN 
    PRINT '' 
    PRINT '' 
    PRINT '' 
    PRINT '/***** SET DEFAULT DATABASES *****/' 
    
    FETCH FIRST FROM login_curs INTO @SID_varbinary, @name, @xstatus, @binpwd, @dfltdb 
    
    WHILE @@fetch_status = 0 
    BEGIN 
    PRINT '' 
    SET @tmpstr = '-- Login: ' + @name 
    PRINT @tmpstr 
    
    SET @tmpstr = 'ALTER LOGIN [' + @name + '] WITH DEFAULT_DATABASE=[' + @dfltdb + ']' 
    PRINT @tmpstr 
    
    FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @xstatus, @binpwd, @dfltdb 
    END 
    END 
    
    IF @include_role = 1 
    BEGIN 
    PRINT '' 
    PRINT '' 
    PRINT '' 
    PRINT '/***** SET SERVER ROLES *****/' 
    
    FETCH FIRST FROM login_curs INTO @SID_varbinary, @name, @xstatus, @binpwd, @dfltdb 
    
    WHILE @@fetch_status = 0 
    BEGIN 
    PRINT '' 
    SET @tmpstr = '-- Login: ' + @name 
    PRINT @tmpstr 
    
    IF @xstatus &16 = 16 -- sysadmin 
    BEGIN 
    SET @tmpstr = 'exec master.dbo.sp_addsrvrolemember @loginame=''' + @name + ''', @rolename=''sysadmin''' 
    PRINT @tmpstr 
    END 
    
    IF @xstatus &32 = 32 -- securityadmin 
    BEGIN 
    SET @tmpstr = 'exec master.dbo.sp_addsrvrolemember @loginame=''' + @name + ''', @rolename=''securityadmin''' 
    PRINT @tmpstr 
    END 
    
    IF @xstatus &64 = 64 -- serveradmin 
    BEGIN 
    SET @tmpstr = 'exec master.dbo.sp_addsrvrolemember @loginame=''' + @name + ''', @rolename=''serveradmin''' 
    PRINT @tmpstr 
    END 
    
    IF @xstatus &128 = 128 -- setupadmin 
    BEGIN 
    SET @tmpstr = 'exec master.dbo.sp_addsrvrolemember @loginame=''' + @name + ''', @rolename=''setupadmin''' 
    PRINT @tmpstr 
    END 
    
    IF @xstatus &256 = 256 --processadmin 
    BEGIN 
    SET @tmpstr = 'exec master.dbo.sp_addsrvrolemember @loginame=''' + @name + ''', @rolename=''processadmin''' 
    PRINT @tmpstr 
    END 
    
    IF @xstatus &512 = 512 -- diskadmin 
    BEGIN 
    SET @tmpstr = 'exec master.dbo.sp_addsrvrolemember @loginame=''' + @name + ''', @rolename=''diskadmin''' 
    PRINT @tmpstr 
    END 
    
    IF @xstatus &1024 = 1024 -- dbcreator 
    BEGIN 
    SET @tmpstr = 'exec master.dbo.sp_addsrvrolemember @loginame=''' + @name + ''', @rolename=''dbcreator''' 
    PRINT @tmpstr 
    END 
    
    IF @xstatus &4096 = 4096 -- bulkadmin 
    BEGIN 
    SET @tmpstr = 'exec master.dbo.sp_addsrvrolemember @loginame=''' + @name + ''', @rolename=''bulkadmin''' 
    PRINT @tmpstr 
    END 
    
    FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @xstatus, @binpwd, @dfltdb 
    END 
    END 
    
    CLOSE login_curs 
    DEALLOCATE login_curs 
    RETURN 0 
    GO
    
    exec sp_help_revlogin_2000_to_2005 @login_name=NULL, @include_db=1, @include_role=1
    GO
  2. ?????? ?? ?????? ?? ?? ??????? ?? ?????? SQL Server ??????? Studio ??? ?????? SQL Server 2005 ?? ??????
???:??? ????? SQL ????? ??? ??? ????? ??????? ???? ??? ?? ???, ?? ?????? ??? ?? ??? ?? ?? ????? ?? ???? ???? ???
CREATE LOGIN LoginName WITH PASSWORD = '', CHECK_POLICY = OFF, SID = MySID

Remarks

  • ?? ??????? ?????? ????????? ????????????? ???? ???? ?? ?? ??? ????? ?????? SQL ????? ??? ??? ???? ????? ?? SQL ????? ?? ????? ?????? ?? ???? ???? ????? ??? SQL ????? ??????? ?? ??????????? ???? ?? ??? ??, ?????? ??????? ?? ?? ????????? ??????? ????sp_help_revlogin????????? ?? ????? ????? ??? ??? ?? ????? ?? ???sp_grantlogin???? ?????? ????? ?? ?? ?? ??? ????? ??? ????? ???? ???? ?? SID ?? ??? ??? ????? ??? ????? ??? ??, ??????? ?????????? ??????? ?? ?? ????? orphaned ?? ?????? ?? orphaned ???????????? ?? ?? ???? ?? ??? ????? ????? ???? ??? ???????? ?????? ?????? ??? SQL ????? ?? ?? ?? ????? ??? ?? ???????? ?? ??? ?????? ????? ??????????, ?? ???? SID ????? ???? ???? ?? ?? ?????????? orphaned ?? ?????? ????? ???
  • ???? ????? ?? ???? ?? ??? ?????????? ????????? ???? ??? ?? ????? ??? ?? ?? ??????? ?? ??????? ?? ???? ?? "orphaned ??????????" ?? ??? ??? ?? ?????? ?? ????? ???? ??? ??? ??? ???? ??????? ????? ????? ???? ???? ?? ?????? ????, ?? ?? ???? ?? ???? ?????????? ???? ?? ????? ?? ????? ???? ??:
    Microsoft SQL-DMO (ODBC SQLState: 42000) 15023 ??????: ?????????? ?? ??? '% s' ???? ?? ????? ??????? ??????? ????
    ????????? ?? ??? ??????? ???????????? ?? ??? ????? ?? ??? ???? ?? ??? ???? ???? ?? ???? ??? orphaned SQL Server ????? ?? ?????? ????? ?? ?? ???? ?? ???, ????? ???? ?? Microsoft ???????? ??? ?????:
    240872??????? ?? ???? SQL ????? ?? ??? ????? ?? ??? ?? ???? ?? ?????? ?? ???????? ?? ?? ???? ?? ??? ???? ????
    ????? ?? ???? ??? ????????? ?? ???sp_change_users_login???????? ????????? ?? ??-??-?? (?? ????? ???? ??? ???????????? ?? ???? SQL ????? orphaned), orphaned ???????????? ?? ??? ???? ?? ???, ????? ???? ?? Microsoft ???????? ??? ?????:
    274188?????? ???????? ??? "Orphaned ?????????? ?????? ??????" ???? ?????? ??
  • ??? ????? ???? ?? ??????? ?? ?????????? ???? ?? ??? ??? ??? ????? SQL ????? ?? ??? ??????? ?? ?? ??? ?? ?????? ??, ????? ???? ?? Microsoft ???????? ??? ????? ????? ?? ??? ???????? ?? ??? ????? ?? ?????:
    314546??????? ?? SQL Server ??? ??? ???????? ?? ??? ?? ???? ?? ??? ???? ????
  • ?? ?? ???? ???? ?? ???? ???encryptopt @??? ????????sp_addlogin?????? ?? ???????? ?????????, ?? ?????????? ???? ??? ??????? ?? ????? ?? ???? ???? ?? ??? ??? ????? ?? ?????? ???? ??? ?? ????????? ?? ???? ??? ???? ??????? ?? ??? SQL Server ???????? ?????? ??? "sp_addlogin (T-SQL)" ???? ?? ??????
  • ???????? ??? ??, ???? sysadminfixed ????? ??? ?? ??????? ?? ??? ?? ????sysxlogins?????? ??? Sysadmin ??? ?? ?? ????? ?????? ?????? ???? ??, ?? ?? ?? ??? ??????? ?? ???? ????? ?? ???????? ???????????? ?? ?? ??????
  • ?? approach ???? ??????? ??????? ??????? ???? ????? ????? ???? ?????? ????? ?? ??? ????? ????? ???? ?? ??? ??????? ??????? ??????? ?? ??????????? ???? ?? ??? ?????? ????? ??? ??? ?? ???? ?? ??? ??????? ??????? ?? ????????? ????, ?? ?? ????? ?? ???? ???sp_defaultdb?????? ????????? ?? ??? ?? ??? ?? ??? ????? ??? ?? ??????? ?? ??????? ?? ??? ??? ???? ?????? ???????? ??? ?? ????????? ?? ????? ???? ?? ???? ??? ???? ??????? ?? ??? SQL Server ???????? ?????? ??? "sp_defaultdb" ???? ?? ??????
  • ???? ?????????? ??????? ?? SQL ????? ?? ???????? ?? ???, ?? ????? ????? ???? ?? ????? ?? ????? case-insensitive ?? ?? ????? ???? ?? ?????? ????? ?? ???-??????, ?? ??? ???? ???? ???? ?????? ???????? ?? ??? ???? ??????? ??? ?????? ?????? ?? ??? ??? ????? ?? ?????????? ?? ??? ?????? ????? ?? ???? ????? ???? ?? ????? ?? ????? ?? ???-?????? ??, ?? ????? ???? ?? ?????? ????? ?? case-insensitive ??, ??? ?? ??????????? ???? ?? ?? ?? ??? ??????? ??? ??? ???????? ????? ?? ??? ??????? ??? ??? ???????? ????? ?? ?????? ???? ??? ?? ?? ?? ?? ???? ??? ??? ?? ????????? ?? ????? ?? ????? ?? ??? ??? ??? ?? ???? ?? ??????? ??? ????? ????? ???-?????? ???? ???, ?? ????? ????? case-insensitive ???, ?? ?? ????? ???? ?? ?????? ?? ?????? ?? ?? ??? ?????? ?? ??? SQL Server ??????? ??????? ??? ???? ??????? ?? ??? SQL Server 7.0 ???????? ?????? ??? "?????? ?? ??????? ?? ????? ????? ????" ???? ?? ??????
  • ?? ?? ?????? ?? ?????sp_help_revlogin?????? ?????, ??? ???? ?? ?? ?? ?? ????? ????????? ?????? ?? ????? ???? ?? ???? ??? ?? ??? ????????? ?????? ????? ?? ????????? ??, ?? ?? ??? ???? ??? ?? ?????? ?? ?? ???????? ???? ?? ????? ??????sp_help_revlogin?????????:
    ?????: ????? 15025, ???? 16, 1 ?????? ???, ????????? sp_addlogin, ?????? 56
    ????? 'test1' ???? ?? ????? ???
    Likewise, ??? ???? ????? ????? ???? SID ??? ?? ??? ?? ????? ?? ?? ?????? ?? ?????? ?? ??? ?? ?? ??? ??? ????? ??, ?? ???? ????? ?????? ?????:
    ?????: ????? 15433, ???? 16, 1 ?????? ???, ????????? sp_addlogin, ?????? 93
    ???? ??? ???????? @ sid ????? ??? ???
    ?????, ???? ?????? ????????????? ?????? ?? ?? ????????? ?? ??????? ????, ?? ??????? ?? ???? ????sysxlogins??????, ?? ??????? ?? ????????? ?? ??? ???
  • ??? SQL Server ??????? ???? ?? ????? ?? ??????????? ?? ??? ???? ?? ??? ??? SID ??? ?? ?? ????? ????? ???? ?? ??? ????? ???? ??? ?????, ??? ???? ????? ?? ?? ????? ??? SID ?? ??? (??? ?? ????? ?? ?? ????? ???????) ??????? ???? ??, ????? ???? ?? ????? ??????? ???? ?? ??????? ????? SID ??? ??? ?? ??? ????syslogins?? ?? ????? ????? ?? ??? ?????? ??????? ?? ???? ?? ??? ?? ????? ????? ?? ?? ??????? ??? question consolidated ???? ??? ??? ?? ?????? ?? ?? ???? ?? ??? ??? question ????? ???? ?? ????? ??? SID ????? ?? ????? ?? ??????? ?? ???????? ??? ?? ?????? ?? ????sp_dropuser????????? ?? ???????? ????, ?? ?? ?? ????? ?? ??? ?? ????? ???sp_adduser???????? ??????????

???

???? ID: 246133 - ????? ???????: 17 ??????? 2011 - ??????: 3.0
???? ???? ???? ??:
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Workgroup Edition
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
??????: 
kbhowtomaster kbinfo kbmt KB246133 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:246133

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com