I see...thanks for all who replied 🙂

Thanks for the response but is there a way to view the transaction logs for auditing purposes?

hi, thanks for the reply.... Below is the returned error message.

OLE DB provider "SQLNCLI" for linked server "test-linked server" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for linked...

thank you for the response...

I will...thanks.. I am also gathering some answers to my questions from some websites.

thank you thank you... now i am able to determine which is the better approach.

Hi... What is the datatype of each field? especially the Job_Title field in Employee and Job_Title tables..

Thank you Bill for the response... But what do you think the disadvantages for the Approach # 2 aside from the schema maintenance?