how can use TRIGGER to effect other DB?

[itay]

how can use TRIGGER to effect table in other DB?

i know i cann't use the USE 'db name'
operator, so what should i use??

thanx itay...

 

[balves]

You would get a better answer in the SQL Server forum. But anyway...

You can fully qualify tables by using dbname.dbo.tablename instead of just tablename (assuming dbo is the owner of the table).

If the databases are on different servers, you need to put the server name in the front of the path [servername].dbname.dbo.tablename, but you also have to define the servers as linked servers in SQL Server so that they can contact each other and pass data. Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer

 

[computergeek]

Hi,

The syntax within your trigger would go something like this:

Select a.column1,
b.column2
From dname..tablename a, dbname2..tablename2 b
where...