The developers here need to be able to view the SPs in SQL studio but not alter them. They also need write permissions on the tables. They are in a windows group which has a sql login. It appears i cant allow them to see SP code without making them ddl admin. There must be a way to do this. Any help would be greatly appreciated.
In properties of the users or role, select securables, then select "Specific Objects" or "All objects of types...", select stored procedures, then select the sp you want them to be able to view, then grant "View Definition".