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 |
|
sp_wiz
Yak Posting Veteran
55 Posts |
Posted - 2001-11-21 : 09:21:28
|
| I have a table that is being replicated to the WEB. The problem i have is it does not contain the necessary fields for setting up Logins,Passwords and levels of access.So I create a Table that will hold this information.OK Trigger here we comeHow do I right a trigger that when a record is updated/inserted/deleted it updates the login table with the new values..IE Candidate table holds ID,EmailAddressI need to get the ID into the Login tableAny Ideas would be great |
|
|
|
|
|