An object's name is actually made up of four components using the following form:
server.database.owner.name
To reference a table in aother database, you'll have to specify the database's name.
use northwind
SELECT * FROM pubs..authors
if you don't specify the owner's name (like my example above), SQL Server will assume that the object is owned by DBO.
-Mike
>Hi all,
>
>I need help regarding sql triggers. I want to use a SQL trigger on a table in one database to trigger on updates of another database.
>
>When user inserts records in table1 of Database1; the table2 of Database2 should get updated with a new record. Is it possible to write a trigger on table1 to achive this ?? I am working in SQL 2000.
>How do I reference the second database with my SQL query?
>
>Thanks and regards,
>Shilpa