q; Running SP with a different user

We are using SQL2000. User insert table in one database DB1 and trigger
insert the record into another database DB2. In this scenario, is it possible
have a trigger in DB1 to execute a stored procedure in DB2 with a different
user?
SQL Server 2000 does not have the functionality to change user security
context. You might consider using cross-database chaining as I mentioned in
your other "q; user running trigger" thread.
Hope this helps.
Dan Guzman
SQL Server MVP
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:A226A886-5748-456F-92F5-08C041CA54DB@.microsoft.com...
> We are using SQL2000. User insert table in one database DB1 and trigger
> insert the record into another database DB2. In this scenario, is it
> possible
> have a trigger in DB1 to execute a stored procedure in DB2 with a
> different
> user?

q; Running SP with a different user

We are using SQL2000. User insert table in one database DB1 and trigger
insert the record into another database DB2. In this scenario, is it possibl
e
have a trigger in DB1 to execute a stored procedure in DB2 with a different
user?SQL Server 2000 does not have the functionality to change user security
context. You might consider using cross-database chaining as I mentioned in
your other "q; user running trigger" thread.
Hope this helps.
Dan Guzman
SQL Server MVP
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:A226A886-5748-456F-92F5-08C041CA54DB@.microsoft.com...
> We are using SQL2000. User insert table in one database DB1 and trigger
> insert the record into another database DB2. In this scenario, is it
> possible
> have a trigger in DB1 to execute a stored procedure in DB2 with a
> different
> user?

q; Running SP with a different user

We are using SQL2000. User insert table in one database DB1 and trigger
insert the record into another database DB2. In this scenario, is it possible
have a trigger in DB1 to execute a stored procedure in DB2 with a different
user?SQL Server 2000 does not have the functionality to change user security
context. You might consider using cross-database chaining as I mentioned in
your other "q; user running trigger" thread.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:A226A886-5748-456F-92F5-08C041CA54DB@.microsoft.com...
> We are using SQL2000. User insert table in one database DB1 and trigger
> insert the record into another database DB2. In this scenario, is it
> possible
> have a trigger in DB1 to execute a stored procedure in DB2 with a
> different
> user?

Q: reporting from two different database

I have two different databases DB1 and BD2. which one table in each.
TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
Now my sub-report in Reporting Services should report ID and sum of
DB1.TableDB1.Amount1 and
DB2.TableDB2.Amount2. How should I
write my query?
select t1.ID, t1.Amount+t2.Amount
from Db1.Table1 t1 join Db2.Table2 t2 on t1.ID=t2.ID should work
Sam
"JIM.H." wrote:

> I have two different databases DB1 and BD2. which one table in each.
> TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
> Now my sub-report in Reporting Services should report ID and sum of
> DB1.TableDB1.Amount1 and
> DB2.TableDB2.Amount2. How should I
> write my query?
>

Q: reporting from two different database

I have two different databases DB1 and BD2. which one table in each.
TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
Now my sub-report in Reporting Services should report ID and sum of
DB1.TableDB1.Amount1 and
DB2.TableDB2.Amount2. How should I
write my query?select t1.ID, t1.Amount+t2.Amount
from Db1.Table1 t1 join Db2.Table2 t2 on t1.ID=t2.ID should work
Sam
"JIM.H." wrote:

> I have two different databases DB1 and BD2. which one table in each.
> TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
> Now my sub-report in Reporting Services should report ID and sum of
> DB1.TableDB1.Amount1 and
> DB2.TableDB2.Amount2. How should I
> write my query?
>

Q: reporting from two different database

I have two different databases DB1 and BD2. which one table in each.
TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
Now my sub-report in Reporting Services should report ID and sum of
DB1.TableDB1.Amount1 and
DB2.TableDB2.Amount2. How should I
write my query?select t1.ID, t1.Amount+t2.Amount
from Db1.Table1 t1 join Db2.Table2 t2 on t1.ID=t2.ID should work
Sam
"JIM.H." wrote:
> I have two different databases DB1 and BD2. which one table in each.
> TableDB1: ID, Amount1 and TableDB2: ID, Amount2.
> Now my sub-report in Reporting Services should report ID and sum of
> DB1.TableDB1.Amount1 and
> DB2.TableDB2.Amount2. How should I
> write my query?
>