In the AdventureWorks database, the details of the vendors are stored in the Vendors table. In addition, the names of the vendors are saved in the VList table of the Vendor database used by another application. According to the requirements, whenever details of new vendors are added to the Vendors table of the AdventureWorks database, the name of new vendors should also be added to the VList table of the Vendor database. | Instructor Inputs Session 17 Solutions to Exercises This session includes exercises of Chapter 11. Chapter 11 Exercise 1 In the AdventureWorks database the details of the vendors are stored in the Vendors table. In addition the names of the vendors are saved in the VList table of the Vendor database used by another application. According to the requirements whenever details of new vendors are added to the Vendors table of the AdventureWorks database the name of new vendors should also be added to the VList table of the Vendor database. How will you solve this problem Note For this exercise you need to provide the Vendor database to the students. For this you can run the script provided in the Datafiles_for_faculty QMDS2005 Chapter11 Exercises folder in the TIRM CD. The vendor list is present in the VList table of the Vendor database. Solution To solve the preceding problem you need to perform the following tasks 1. Create a service program. 2. Create message types contract queues and services. 3. Create a trigger on table. 4. Verify the functionality. NIIT Instructor Inputs .
