Microsoft KB Archive/113402

{|
 * width="100%"|

BUG: SQL Transfer Manager Does Not Transfer Aliases

 * }

Q113402

-

The information in this article applies to:


 * Microsoft SQL Server version 4.2x

-

BUG# NT: 9959 (4.2)

SYMPTOMS
SQL Transfer Manager does not transfer aliases within a database when doing a transfer. However, database users are transferred.

WORKAROUND
After the database has been transferred, recreate the aliases for the database manually using SP_ADDALIAS.

STATUS
Microsoft has confirmed this to be a problem in SQL Transfer Manager version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords : kbtool

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2