missing stored procedure in AdventureWorksDB pls help

Question

hi every one  i have a problem with sql server and visual studio 2005 iam using a microsoft workshop book to learn how to connect the sql server with VS and Iam using AdventureWorksDB to complete or answering the exercises but i figure out that some of stored procedures that should be in AdventureWorksD didnt Exist like uspGetProductPrices stored procedure or uspCreateProductSuggistionTable stored procedure and others that should be in the db to continue the exercises in that book

pls help me how can i find them or add them to the db 

thank u 

   

Answer 1

Did the workshop lab material come with a CD-Rom? Looking at the following...

http://www.scribd.com/doc/20337363/Unit-0-Introduction

...in the section Workshop materials it talks about a CD with the source code on it, subsequent sections of the lab material mention the stored procedures you stated above. The copies of AdventureWorks I have do not have these stored procedures so it looks like it should be provided with the lab materials you have. There is another reference to one of the stored procedures here...

http://social.msdn.microsoft.com/Forums/sk/csharplanguage/thread/76437b20-a1f3-4959-9d27-638fa13d7294

...hopefully these give you some leads to find the lab materials.

Thanks

---

/Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005/2008), MCAD, ITILv3, OCA 11g) Please click the Mark as Answer button if a post solves your problem

Answer 2

thank u my friend for ur answer i discover that each unit has its own setup for adventureWork database and i must at the start of each one execute this setup to create those stored procedures 

now i face another problem in unit 7 in the same book i try to send a message to specific email from application form i made and for this i need a SMTP server , but in iis 7.5 this feature not available i even dont have server manager on my computer how can i solve this problem 

i try a 3rd party program called free smtp server but it didnt work  (i add the address and the port number that this program use to my code and an error message appear ) here is the pic    plz help me guide me to the solution step by step 

Answer 3

What is you OS version and edition ?

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 4

  windows 7 home premium