Re: Read-only Stored procedure Display in SQL 2005

Ron,

This has already been answered in the .server newsgroup. Please do not
multipost.

--
HTH
Kalen Delaney, SQL Server MVP


"Ron" <ron@xxxxxxxxxxxxxxxxx> wrote in message
news:Xns97E36AD552AF1WBT39212565@xxxxxxxxxxxxxxxx
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

  • Re: SQL Server 2005 Newbie
    ... Tibor Karaszi, SQL Server MVP ... Sylvain Lafontaine, ing. ... On my windows XP Pro SP3 workstation I have SQL 2000 running I was trying to connect via Enterprise Manager to the new SQL 2005 server ...
    (microsoft.public.sqlserver.server)
  • Re: ReportIoError 2 - any ideas?
    ... job - then modify the schedule as required. ... using DBCC SHRINKFILE to reduce the ldf file size. ... Rerunning the backups through Enterprise Manager. ... My colleagues know even less about SQL Server ...
    (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)
  • 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: How to check if SQL 2000 is installed? (SBS 2003 SP1 Problem!)
    ... > Enterprise manager" and view the databases running on your server (just ... > click the + until you see databases), then you definitely have a SQL ... But I have sometimes installed two Tools called "MSDE Manager" and "MS SQL ...
    (microsoft.public.windows.server.sbs)
Quantcast