RENAME SYSTEM ADMIN NAME
-
HI Everyboody,
How can i change SYSTEM ADMINISTORS NAME plz explain me
cureent my system admin name is 'bindu' it will rename 'RENU' How plz explain me
Thx
subu
-
You can change the login name, but using the properties for that login.
-
If you are pertaining to the Server Login Name then follow this steps
To Prevent Ad Hoc Error Message
1. Right CLick your server name
2. Choose properties
3. Choose Server Setting
4. Under Server Behavior, enable(check) "Allow modification to be made blah....blah.."
USING TSQL
1. Go to master (no.2 and 3 is a query statement)
2. Select name from sysxlogins
3. UPDATE sysxlogins SET name = <new_name> WHERE name = <old_name>
Enterprise Manager
1. Click master
2. Click Table
3. Right Click sysxlogins
4. Choose Open table, return all rows
5. In the "name" column change the server log in name you want to change
6. Refresh Server (Not restart the server huh)
DONE your server log in is now changed 😎
"-=Still Learning=-"
Lester Policarpio
-
Hi Friend,
Thank u for ur reply
In Enterprise manger it will working
but in Query Analyser it is not working
can u give some good suggestions plz
Thanku:hehe:
-
To Prevent Ad Hoc Error Message
1. Right CLick your server name
2. Choose properties
3. Choose Server Setting
4. Under Server Behavior, enable(check) "Allow modification to be made blah....blah.."
- Did you do that procedure before running the select and update statement in QA?
"-=Still Learning=-"
Lester Policarpio
-
Lester, probably not a good idea to go around modifying system tables directly. Can get you into an awful pickle with Microsoft when you have a problem you want them to fix. 😀
Better solution is to add the user 'RENU', assign them required permissions, then drop the user 'bindu'.
If there are permissions that need to be maintained, then search the script library on this site for some T-SQL code that will script out the permissions. Really though permissions should be assigned to groups and roles, then users are added to the Groups or Roles. Then you can change users without any problems.
--------------------
Colt 45 - the original point and click interface
-
philcart (9/25/2007)
Lester, probably not a good idea to go around modifying system tables directly. Can get you into an awful pickle with Microsoft when you have a problem you want them to fix. 😀Better solution is to add the user 'RENU', assign themrequired permissions, then drop the user 'bindu'.
If there are permissions that need to be maintained, then search the script library on this site forsome T-SQLcode that will script out the permissions. Really though permissions should be assigned to groups and roles, then users are added to the Groups or Roles. Then you can change users without any problems.
Ahh noted 🙂 thanks for the info philcart this procedure came from my boss when we migrate sql version 7 to sql version 2000.
"Can get you into an awful pickle with Microsoft when you have a problem you want them to fix" - can you site some intances/example about this??
"-=Still Learning=-"
Lester Policarpio
-
Very simple : if you mess with the system tables in any way (except for selects), then MS has the right to NOT support your application, and they will use it. This becomes a big problem (for you), when you inadvertantly break something on the server while messing with this stuff, then the customer supports tells you to figure it out on your own... or pay huge amounts of money to have them figure it out for you.
-
Ouch :w00t: ok thanks very risky to play with the system tables
"-=Still Learning=-"
Lester Policarpio
-
Other words that come to mind (after proper warning has been heard) : stupid, wreckless, job buster, career ender, go back to live with your parents...
😛
--Testing to see how the site handles multiple edits?!
For anyone who cares to know, it shows the edit only once even when multiple edits are done for the same thread.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply