Running Stored Procedures made by other users

When I started stored procedures some time ago and linking them or executing them using the Asp.net applications. I had to give ASPNET user permission to run the stored procedures. This was a 1-2 minute job but later it became annoying since I had to right click on each stored procedure and change its permissions.

So, I found a way that you can use to give permission to the ASPNET user to run stored procedures.

Make your stored procedures like this:

CREATRE PROCEDURE [COMPUTERNAME\ASPNET].[StoredProcedureName]

When you try to run your stored procedure in SQL Query Analyzer you can type the full name of the procedure.

[COMPUTERNAME\ASPNET].[StoredProcedureName]