Viewing 15 posts - 38,251 through 38,265 (of 39,456 total)
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
Roughly the same connection, but the rendering code may be different. QA builds a grid and formats from the results, which can be slow for large result sets.
Steve Jones
January 23, 2002 at 10:57 am
January 23, 2002 at 10:54 am
Can you define "last accessed". Is this the last change or the last time a select occurred against a table. Or the last time a stored procedure was executed?
Steve Jones
January 23, 2002 at 8:17 am
Viewing 15 posts - 38,251 through 38,265 (of 39,456 total)