I have a production database on the server. But I want to get that complete database in my local machine both Tables and SPs. How can I do that? Note: I have tried using the SSMS Export service but I got only tables, not the SPs. I have attached the SS of how I tried but I got only Tables. So I want to know the way I can get Tables and SPs both.