Home Forums SQL Server 7,2000 Administration SQL 6.5 - Alias RE: SQL 6.5 - Alias
neder
SSC Eights!
Points: 888
More actions
July 14, 2003 at 2:14 pm
#465442
user aliases are in table sysalternates. verify this table and chech the ids against the syslogins. You can use sp_dropalias to drop the user alias or manually deleting it from the sysalternates tables provided that the user does not own any objects