SQL Server Performance

Transfer Login Task (DTS)

Discussion in 'SQL Server DTS-Related Questions' started by ASULEJ, Feb 24, 2004.

  1. ASULEJ New Member

    I have a problem with „Transfer Login Task” (DTS) which I use to copy the logins from the primary server to the secondary server

    When I execute the package it returns error – 1 task fail during execution – Unspecified error

    What is funny, logins are transferred to the standby server.

    But not all data is right, the logins default language on the standby server is different from the primary server. I#%92m worrying that there are more differences.

    Does anybody know how to fix it?

    This is the output from the SQL Profiler:

    set noexec off set parseonly off
    go
    -- 'sp_addlogin' was found in the text of this event.
    -- The text has been replaced with this comment for security reasons.
    go
    set noexec off set parseonly off
    go
    -- 'sp_addlogin' was found in the text of this event.
    -- The text has been replaced with this comment for security reasons.
    go
    set noexec off set parseonly off
    go
    exec sp_configure 'allow updates', 0
    reconfigure with override
    go
    set noexec off set parseonly off
    go
  2. satya Moderator

Share This Page