We have a developer team that has been accustomed to viewing stored porcedure code through Enterprise Manager in SQL2000. We noticed that when having the same DataReader rights in SQL Management Studid(SQL2005) they cannot view the stored procedure code. Is this a bug in SQL2005 or is there another way/method(without maintenance nightmares) to allow them to view the stored procedure without giving them dbo permission.
Thanks in Advance,
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!