Insert statement

[ramya]

I need to insert values into two different tables in different database.

This Store procedure is in Database1,

INSERT INTO [DataBase1].[dbo].[UserMaster]
(UserFirstName,UserLastName,[Login],[Password],Phone,Email,SecondaryEmail) VALUES
(@UserFirstName,@Userlastname,@Login,@Password,@Ph one,@Email,@SecEmail)


INSERT INTO [DataBase2].[dbo].[UserMaster]
([Login],Pswd) VALUES
(@Login,@Password)

I am not able to insert in DataBase2.
I am not sure where am I wrong.

[rmiao]

What kind of permission do you have in db2?

[ramya]

I solved it myself. It was in sp_adduser. I changed the procedure name and it works.