No, there is no way to set a username or password on a procedure to prevent someone else from looking at the code. The only thing you can do within the SQL Server is use the WITH ENCRYPTION option when creating the procedure.
Denny
--Anything is possible. All it takes is a little research. (Me)
Skeezwiz,
you seem to be genuinely concerned about the SP's code. Depending on how you execute the code you may consider using a DTS package with owner and user password. That added to Windows authentication should fixed a great deal of your problem...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.