Hi,

I also want to do something like this posting above but it does not work when I try to modify your statements above. I am currently using asp to do...

thamks, i found the error

Thanks a lot

It worked.

I Looked at sp_change_users_login. I don't what to change and how should I do it. I am not familier with sp.

Can u please write detailed steps for me.

Is there a way I can change the object owner. I want to change the stored procedure owner.

Thankyou very much,

It worked after restrating SQL Server.

Thanks,

I managed to change the security authentication using registry.

But still get this error on my asp page

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL...

No it does not show any error message. Yes, I am logged in using the windows system account and it has all privilages to change this setting. Maybe you can...