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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Trigger Questions

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 come

How 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,EmailAddress

I need to get the ID into the Login table

Any Ideas would be great

   

- Advertisement -