Emilio.Mendoza (9/10/2008)

---

Thanks for the reply I've already use those options, probably I didn't explain myself correctly, I need to have the DBO name and the login 'NT AUTHORITY\NETWORK SERVICE' I have read smoe post where they say this can't be done, but I already checked some DB that shows exactly that.


SO it is possible but how can you do that to show in the NAME column DBO and the Login of the DB 'NT AUTHORITY\NETWOK SERVICE'?

I tried the sp_changedbowner

Also sp_change_users_login

Thanks for the help

Emilio.Mendoza (9/10/2008)

---

Thanks for the reply I've already use those options, probably I didn't explain myself correctly, I need to have the DBO name and the login 'NT AUTHORITY\NETWORK SERVICE' I have read smoe post where they say this can't be done, but I already checked some DB that shows exactly that.

SO it is possible but how can you do that to show in the NAME column DBO and the Login of the DB 'NT AUTHORITY\NETWOK SERVICE'?


Thanks for the help

vgullotta (3/10/2009)

---

I am attempting to change a dbo login name and can't figure out how. Let me explain a little so you get what I am looking for.

This dbo login name is: ;test
I need to edit it to be: test

The reason for this is that I don't want to change the password on this login name, I just want to edit the username. It is basically because when we disable a user, our disable script or something like that changes it to ';username' from 'username'. Now I need to enable this login by simply renaming the login, but I don't know how to do it. Any suggestions?

Thanks in advance,