October 7, 2008 04:42pm pdt

1. chapmandew 2,223,259
2. angelIII 1,997,731
3. mark_wills 631,410
4. aneeshatti... 607,479
5. ScottPletc... 456,851
6. EugeneZ 366,402
7. ee_rlee 353,240
8. BrandonG... 340,310
9. acperkins 335,429
10. dtodd 304,879
11. momi_sa... 194,132
12. cs97jjm3 188,038
13. matthews... 169,999
14. appari 166,334
15. nmcdermaid 165,158
16. rickchild 165,060
17. brejk 163,902
18. dqmq 156,258
19. Thomasian 153,702
20. dportas 141,305
21. ptjcb 140,761
22. dbaSQL 139,392
23. bhess1 134,605
24. mwvisa1 128,997
25. MohammedU 125,975

1. angelIII 10,954,144
2. aneeshatti... 4,665,358
3. acperkins 4,323,889
4. ScottPletc... 4,270,903
5. arbert 2,245,195
6. chapmandew 2,223,259
7. Lowfatsp... 2,174,384
8. EugeneZ 1,642,564
9. imran_fast 1,482,261
10. rafrancisco 1,460,132
11. Hilaire 1,221,775
12. nmcdermaid 1,149,742
13. Nightman 1,146,504
14. Mr_Peer... 1,087,815
15. ptjcb 1,074,620
16. bhess1 1,071,597
17. dtodd 891,222
18. adathelad 777,208
19. Sirees 776,352
20. appari 753,571
21. BriCrowe 722,959
22. matthews... 692,331
23. amit_g 683,229
24. mark_wills 631,410
25. ShogunW... 619,598

12.09.2007 at 10:47PM PST, ID: 23012414

	[x] Attachment Details

How to change user name in sql server 2000 database

Asked by techprocess in MS SQL Server, Databases Miscellaneous

Tags: change, user, sql, 2000, server

I have a database which is on sql server 2000.

It has a user as sa.

Now I wanna a user with DBO rights with other name.
E.g DBUser.

So that I can rename sa to DBUser.

or create new user DBUser.

Can anybody help me on this.

Thanks in advance...Start Free Trial

Keywords: How to change user name in sql serve…

	Title
1	SA password lost!
2	users with dbo
3	remove dbo in ms-access
4	Name became DBO - how to change t…
5	DSN connection to an access databas
6	SAS-How to transpose all distinct val…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

How to change user name in sql server 2000 database

Asked by techprocess in MS SQL Server, Databases Miscellaneous

Tags: change, user, sql, 2000, server

About this solution