Read-only Stored procedure Display in SQL 2005

In sql 2000 the development team could look at the contents of an SP in
enterprise manager when they had read only access to the database.

The same does not hold true to sql 2005 and the management studio. How do
I give the development team read only access to the SPs in sql 2005.

Thanks,
Ron
.

Relevant Pages

  • Maybe the Records Are There After All
    ... The indication that the records were DELETED is that Server Enterprise ... Type in Server Enterprise Manager and then was making notes and documenting ... the larger database from last night STILL SAYS that it has ZERO records ... Is there some way to monitor the things that SQL is doing in the BACKGROUND ...
    (microsoft.public.sqlserver.server)
  • Re: software needed to input data
    ... ENTERPRISE MANAGER give you a simple one table at a time ... Your programmer might have proprietary rights to the ... >If you are database savvy, you can always get into SQL ...
    (microsoft.public.sqlserver.server)
  • Re: Newbie - Help!
    ... This is my error message: ... CREATE DATABASE permission denied in database 'master'. ... database 'pubs' to file 'D:\Program Files\Microsoft SQL ... I was able to find a trial version of the Enterprise Manager. ...
    (microsoft.public.sqlserver.msde)
  • Enterprise Manager Query functionality
    ... If you right click on a table in a database in Enterprise Manager you have ... Re installing SQL did not resolve this issue. ...
    (microsoft.public.sqlserver.setup)
  • Re: Recreating database on production machine?
    ... If you want to recreate the database with a script, ... SQL Server MVP ... >I know that you can use the graphical tools in Enterprise Manager to create ...
    (microsoft.public.sqlserver.programming)