Re: SQL2000 - Can NOT add a user to a DB
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 06/25/03
- Next message: SQL Server Development Team [MSFT]: "Re: sp_password"
- Previous message: Lint: "SQL2000 - Can NOT add a user to a DB"
- In reply to: Lint: "SQL2000 - Can NOT add a user to a DB"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 25 Jun 2003 13:37:30 -0400
Try:
sp_change_users_login 'Auto_fix', 'testgod'
-- Tom --------------------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com/sql "Lint" <lintadsl@yahoo.com> wrote in message news:012501c33b3f$e2224120$a401280a@phx.gbl... Hello, I am trying to add a user to TEST DB which I got it from another SQL server. The test DB originally from SQL01 and I moved the DB to SQL02 which is our new SQL server. So the DB has a user called testgod and SQL02 did not have that user so I created it on Security. When I looked at the Test DB's users section, nothing in it. So I click on New Database user, and tried to add testgod user to that DB, I get an Erro 15023: User or role 'testgod' already exists in the current database. I am a newbie DBA and the DBA class is coming up. So, please give me a little more details on your idea. Thanks in advance. Sunny
- Next message: SQL Server Development Team [MSFT]: "Re: sp_password"
- Previous message: Lint: "SQL2000 - Can NOT add a user to a DB"
- In reply to: Lint: "SQL2000 - Can NOT add a user to a DB"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
