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 |
|
espanolanthony
Starting Member
9 Posts |
 Posted - 2009-09-18 : 08:44:40
|
| I am new to SQL and i have a problem as below:- I have SQL Server 2005. Let me explain what is wrong.I have to backup a database "XYZ" from server 1 and then restore that backup file as "ABC" in server2. Now that seems easy but i have created a maintenance plan for doing this. steps are shown below:-1) takes a backup of "XYZ" database from server1.2) then restores as "ABC" to server2.3) then creates users and logins to the "ABC" database that were there in "XYZ" database.everything worked fine until now but when i added a new user to the database "XYZ" i got an error in the create login part. see the error below:-sp_change_users_login @Action='update_one', @UserNamePattern='IBM\\DBtsmith', @LoginName='IBM\\DBtsmith'" failed with the following error: "Incorrect syntax near 'sp_change_users_login'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.i think some problems witht he orphand users but no idea still.please help. |
|
|
espanolanthony
Starting Member
9 Posts |
Posted - 2009-09-18 : 09:10:07
|
| any help friends??????????? |
 |
|
|
|
|
|
SQL Server login error