BUG: Schema Generate Does Not Produce Aliases

ID: Q113160

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2
Microsoft SQL Server version 4.2x

BUG# 9891 (4.2)

SYMPTOMS

Object Manager's schema generate function does not put aliases into the generated script. If a database has aliases, schema generate will not include them in its generated scripts. For example, if a site does


   use pubs
   go
   sp_addlogin testlgin, NULL, pubs, NULL
   go
   sp_addlogin tstalias, NULL, pubs, NULL
   go
   sp_adduser testlgin, testuser, testgrp
   go
   sp_addalias tstalias, testuser
   go

and then uses schema generator to generate a script with all objects, users and logins, the alias tstalias will not be included in the generated script.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 4.2 and SQL Server version 4.2b for OS/2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: Windows NT

Keywords : kbtool SSrvObj_Man kbbug4.20 SSrvWinNT
Version : 4.2b | 4.2
Platform : OS/2 WINDOWS
Issue type :