RE: .Net interface to vss for sql 2000 stored procedures

From: sgerwie (sgerwie_at_discussions.microsoft.com)
Date: 09/02/04


Date: Thu, 2 Sep 2004 07:37:10 -0700

We do use Windows Authentication for the developers, however, in order to set
this up, SQL services has to run with "sa" authority and Admin rights on the
server, therefore, it automatically gives everyone "sa" rights to SQL. It
doesn't matter

"MAURICIO" wrote:

> You can use Windows Authentication for developers staff
> "sgerwie" wrote:
>
> > We would like to use the version control for sql stored procedures through
> > .net, however, according to Microsoft's implementation procedures it gives
> > developers "sa" authority. Does anyone know how we can set this up without
> > the developers having "sa" authority on our database?