Microsoft KB Archive/113160

{|
 * width="100%"|

BUG: Schema Generate Does Not Produce Aliases

 * }

Q113160

-

The information in this article applies to:


 * 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 version 4.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

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2