SQL Server Performance Forum – Threads Archive

Looup and Watches

Hi, Know I am coming with a ‘theoretical’ question.
I search on google for a while but i did not find anything usefully. I want to understand exactly what lookups and watches really are. What are the difference between them. I seen a lot of example and I know how to use them, but I really don’t know theoretical part. From the help file of an application that i use I could extract this:
About watches: some forms of data analysis using an audit log table
About Lookups: captured data comes from a table other than the audited one.
a relationship between table and returned value from that table. But this information doesn’t help me too much. I want to understand them better; the difference between them. So, pls could anyone of you give a little help?
If there are some description about that on this forum pls show them to me (and sorry for posting, in this case, again) Thanks, Jack Bower
software developer
IATAR Studio
http://iatar.port5.com

Lookups performs data cleaning tasks such as standardizing data, correcting data, and providing missing values. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

Thanks Satya.
O I made a point about lookups. But I still can figured a good difference between lookups and watches (capture function of a data)…
Thanks, Jack Bower
software developer
IATAR Studio
http://iatar.port5.com

Can you explain your need in this regard? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

Hi Satya, I am sorry for this big delay, but was busy.
So what is about. I am currently using an application that allow me to create watches and lookups for data changes in database. What i did not understand what exactly lookups and watches are. And how (or at what) I may use them. Thanks, Jack Bower
software developer
IATAR Studio
http://iatar.port5.com

]]>