This is what I have tried so far. It didn't work on SQL2k

select suser_sname()

--ensure no proc exists already

if object_id('dbo.test') is not null

drop proc dbo.test

go

if object_id('test') is not null

...

Thanks. I'll retry that again some time later. Is your aliased user a ntuser or a sqluser?

Yes I did. This userx is a

* islogin

* isntname

* isntuser

And the associated uid > 5

When userx created a new db object after executing

EXEC sp_addalias 'domain\userx', 'dbo'

I have tested the behavior I described in my last posting in a Win2k/SQL2k environment. And I know that If users prefix dbo. in any db object he/she created then...

No. I don't get any error. The problem is that even after running

EXEC sp_addalias 'domain\userx', 'dbo'

All the db objects created by userx still owned by 'domain\userx' not by 'dbo'.

Andy,

Does the statement:

EXEC sp_addalias 'his login', 'dbo'

only work for SQL 7 server not SQL 2000?