Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
siva.meti
Starting Member
32 Posts |
 Posted - 2007-09-24 : 12:37:04
|
| HI Everyboody,How can i change SYSTEM ADMINISTORS NAME plz explain mecureent my system admin name is 'bindu' it will rename 'RENU' How plz explain meThxMeti BEST OF THE BEST |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-09-24 : 12:37:50
|
| You have to drop "bindu" and add "RENU".Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
siva.meti
Starting Member
32 Posts |
Posted - 2007-09-24 : 12:43:52
|
| Thank u for ur replycan u plz tel me the command of MS SQL SERVER 2000 to change the name Can u plz tel me How to in GUI nothing but ENTERPRISE MANGERThxMeti BEST OF THE BEST |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-09-24 : 12:52:47
|
quote:
Originally posted by siva.meti
Thank u for ur replycan u plz tel me the command of MS SQL SERVER 2000 to change the name
As I said in my previous post, you cannot change the name. You need to drop the user and create a new user with the new name.quote:
Originally posted by siva.metiCan u plz tel me How to in GUI nothing but ENTERPRISE MANGER
What? I dont know what you are asking. Try again..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-24 : 23:17:33
|
| What you asked are covered in sql books online, just read it. |
|
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-09-25 : 13:27:09
|
| You can rename the login from GUI...No idea about scripts.RKNAIR |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-25 : 23:02:50
|
| Alter login statement. |
|
|
|
|
|
|
CHANGE THE SA name