ASE : Drop an alias, with objects linked to login

sp_configure 'allow updates',1
go

begin tran
go

update sysobjects set loginame = 'jsmith' where loginame = 'rjones'
go

commit tran
go

sp_configure 'allow updates',0
go

sp_dropalias 'rjones'
go