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 - 2003-08-01 : 07:46:31
|
| Andy writes "Here's my situation:I am running Win 2003, SQL Server 2000 SP3 Std.I have 2 databases both with what I will call "user accounts" (one db is for my mail server, the other for my intranet.) I want to create a system (from what I gather, using triggers) so that when a new email account is created in the first db, a matching account is created in the second.(I would presume that would be one of triggers on the mail server db.)Next, I need it so that an account for the intranet cannot be created without an account on the mail server ( I think I have a trigger written that works for this.) Then I need either database to allow the password field in their respective tables to be updated and automatically update the other. The hard part I am running into is how do I make it so my ON UPDATE trigger only looks to see if the password field was updated and not any other field? Basically I am just trying to "simulate" a single sign on solution for my web systems. Any help you can give would be greatly appreciated." |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-08-01 : 08:05:25
|
| If you have two tables on two databases that you need to keep in sync, you should use replication.Jay White{0} |
 |
|
|
|
|
|
Trigger to Update a different database when a single field is changed.