Thursday, March 8, 2012

.Net interface to vss for sql 2000 stored procedures

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?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?|||We do use Windows Authentication for the developers, however, in order to se
t
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:
[vbcol=seagreen]
> You can use Windows Authentication for developers staff
> "sgerwie" wrote:
>

No comments:

Post a Comment