I am trying to create a trigger to update a datetime field when a user
logs in to their account. Is there a way to create a trigger that
updates a field when the table is accessed? The only other possible
way I can think of to accomplish this would be to write code that
updates a field on submit so that it trips the trigger I have to update
the time. This does not seem especially efficient, though.
Re: Triggers - Inserted and Deleted Tables ... If you have a DML statement that affects more than one row, ...trigger will fail - I mean, you won't get an error, but the trigger action ... SELECT @OldBalance = Balance ... and I update an account holders checking and savings account. ... (microsoft.public.sqlserver.programming)
Re: call to xp_cmdshell from trigger problem ... I'll look this over maybe there is something we missed in the vbs script... >> account.... >> script that is called by the trigger the client get nothing. ... (microsoft.public.sqlserver.server)
RE: Msg 15404: Could not obtain information about user ... I understand that when you changed your DAEMON startup account from ... What is the type of the trigger MyTable_MyUpdate, ...Microsoft Online Community Support... or a Microsoft Support Engineer within 1 business day is acceptable. ... (microsoft.public.sqlserver.security)
Re: Trigger on D3 DM tables ... The logic for the trigger is no biggie but my wonder is 'where' it ...RUNTIME-ERRORS which might cause me a 'circular logic' error). ...Account ACCT has a table ACCOUNTS which has a trigger on data portion. ...Account USER has a qpointer to ACCOUNTS. ... (comp.databases.pick)
Re: call to xp_cmdshell from trigger problem ... The application user is a SQL Server account and not a Windows user account. ... try a test and see if the client gets the required info. ... >> database and causes a trigger to fire and starts a process to notify the ... (microsoft.public.sqlserver.server)
