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.
| Author |
Topic |
|
jogin malathi
Posting Yak Master
117 Posts |
 Posted - 2007-04-09 : 03:31:18
|
| Hii want to audit a tablesFor That i created audit tablesIn that table i want to store data asall field related to old data table and from which system user had changed the dataFor this system id i used host_id() but the iam not getting the idMalathi Rao |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-09 : 03:36:39
|
what system id ?host name ? host_name()
KH |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-09 : 04:39:51
|
| Host_ID() returns workstation ID number. Are you getting any error? Can you show us the code which you use to insert this Audit information?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
jogin malathi
Posting Yak Master
117 Posts |
Posted - 2007-04-09 : 05:44:12
|
I want the machine id frm where the data has been updated(i.e) frm which systemquote:
Originally posted by harsh_athalye
Host_ID() returns workstation ID number. Are you getting any error? Can you show us the code which you use to insert this Audit information?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
Malathi Rao |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-09 : 05:50:13
|
quote:
For this system id i used host_id() but the iam not getting the id
So what do you get ? and what is the value you are expecting from host_id() ?
KH |
|
|
|
SQLUSA
Starting Member
28 Posts |
Posted - 2007-04-09 : 08:11:47
|
| If you have a middle-tier, you are not going to get the host ID.Kalman Toth, Database, DW & BI ArchitectSQL Server 2005 Training - http://www.sqlusa.com |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-04-10 : 01:04:08
|
| It is very simple for the front-end application to supply.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
How to write QUERY