use of host_name( ) in triggers
From: Ida (idapay@yahoo.com)
Date: 05/28/02
- Next message: Peter Koller: "Analysis services"
- Previous message: Andrey Koubychev: "Re: password encrption hash function"
- Next in thread: Edward Bogaard: "use of host_name( ) in triggers"
- Reply: Edward Bogaard: "use of host_name( ) in triggers"
- Reply: Simon Su: "RE: use of host_name( ) in triggers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Ida" <idapay@yahoo.com> Date: Tue, 28 May 2002 00:40:40 -0700
Hello! =)
I need to find out who is making scrupulous changes in one
of the database tables. What I did was to create a trigger
for an update event for the affected table. This table
should populate a temporary table that will record the
login, computer name and date (using SYSTEM_USER, HOST_NAME
() and GETDATE() ) in which the changes were made.
My problem is if the host_name is used within the trigger,
the record in the temporary table will have a NULL value
for the host_name. However, if I run "SELECT HOST_NAME()
from the query analyzer, the host_name is returned.
Question: What must I do in order to get the desired
result using HOST_NAME?
I hope to get help from you, guys. Many thanks in advance.
=)
Kind regards,
Ida
- Next message: Peter Koller: "Analysis services"
- Previous message: Andrey Koubychev: "Re: password encrption hash function"
- Next in thread: Edward Bogaard: "use of host_name( ) in triggers"
- Reply: Edward Bogaard: "use of host_name( ) in triggers"
- Reply: Simon Su: "RE: use of host_name( ) in triggers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
