Viewing 15 posts - 38,596 through 38,610 (of 39,804 total)
Sorry,
select host_name()
The user will be
select suser_name(), user_name()
depending on if you want login or db user. You can get all of these from sp_who
Steve Jones
January 23, 2002 at 12:19 pm
January 23, 2002 at 12:05 pm
The best way is to insert the audit record by joining back to the original table. To handle multi row inserts, I've done the following.
in trigger:
if update()
begin
...
January 23, 2002 at 12:04 pm
January 23, 2002 at 12:02 pm
Is this a copy objects task? If so, I've had numerous problems with those.
Steve Jones
January 23, 2002 at 12:01 pm
January 23, 2002 at 11:59 am
Or suck in the data into a table and process it there. I agree with Brian and Andy, pls post more info.
Steve Jones
January 23, 2002 at 11:58 am
you can get the hostname() from the system, but this is passed by the client. Also, because of proxy servers and NAT, IP addresses are not necessarily unique.
Steve Jones
January 23, 2002 at 11:57 am
January 23, 2002 at 11:56 am
January 23, 2002 at 11:14 am
the other alterative is to write something that stores the connection info and then compares that with the current info and takes action. Then run this every minute or so....
January 23, 2002 at 11:13 am
January 23, 2002 at 11:07 am
January 23, 2002 at 11:04 am
Don't think so. I think the sort order while apply for both tables and data.
Steve Jones
January 23, 2002 at 11:00 am
Viewing 15 posts - 38,596 through 38,610 (of 39,804 total)