MS SQL Server: Trigger that needs to log/insert into different DB with different UserName/Password
Posted on 2007-11-20
I need to add a trigger in my Database to log the Payments that we make into Accounting Database where I have SQL Server username and password.
The Accounting won't add me as a user in there DB but had given me there limited priviledge Username and Password. At insertion of a payment made from our System, I need to add the following trigger to insert into Accounting database's AccountLog table using the UserName and Password provided
INSERT INTO AccountLog( CustomerID, Emp_ID, AmountPaid,Date_Time)
select inserted.CustomerID, inserted.Emp_ID, inserted.AmountPaid, inserted.Date_Time
Is it possible to do?