How do you delete an aliased user
You can use sp_dropalias do drop the legacy SQL Server 2000 user alias in SQL Server 2008 R2:

 EXEC sp_dropalias N'&lt;name-of-aliased-login-here&gt;';


This stored procedure was removed in SQL Server 2012 later versions.