Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-20 : 14:01:52
|
cheryl writes "Hi,
I have a table in A database and i want to write a insert trigger function to trigger a table in B database.And i have the following sytnax:
CREATE TRIGGER tr_A_insert ON [A]
FOR INSERT
AS
...
INSERT B.dbo.tableB(user_id,username,password,sex) values (@fx_new_id,@username,@password,@sex)
when i try to insert something into table A, it keeps giving me the error message "Invalid object name".
I've no idea on how to trigger a table in B database, can you help? Thanks alot!
Cheers!" |
|
|
|
|
|
using trigger for different databases