BUG: SQL Transfer Manager Does Not Transfer Aliases

ID: 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 SSrvTrans kbbug4.20
Version : 4.2 4.21
Platform : WINDOWS
Issue type :