answersLogoWhite

0

In MS SQL Server, you just need to grant exec permissions to public;

grant exec on sp_ProcedureName to public

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

How do you compile a PLSQL procedure?

You can do that with Sql*Plus: SQL> CREATE OR REPLACE PROCEDURE foo ... IS ... END foo; / SHOW ERRORS


What statement is used to execute a procedure?

Just use the name of the procedure. For example, if I have a procedure addEntry(a NUMBER, b OUT NUMBER) then I can call it by: DECLARE x NUMBER; BEGIN addEntry(5, x); END . run;


Can you uses sql stored procedure in qlikview and if you can script examples please?

In qlikview: SQL EXEC [dbo].[StoredProcedureName];


Difference between sql function and sql procedure?

Function is must be return the value but procedure cannot be returned, for more information please visit the link : http://youropensource.com


How do you define an integer in SQL Server?

with the keyword int: eg: declare @myIntegerVariable int


Can you declare SQLCODE in working storage section?

No, you cannot declare SQLCODE in the Working-Storage Section of a COBOL program. SQLCODE is a special variable used to indicate the success or failure of SQL statements and is automatically provided by the database interface when executing SQL commands. Instead, it is typically referenced directly after executing SQL statements without needing an explicit declaration in the Working-Storage Section.


Which is an example of a PLSQL subprogram?

A PL/SQL subprogram is equivalent to a procedure or function in conventional procedural programming.


How do you declare a functions?

public void throwRock() { }


What are stored procedures in data bases?

Stored procedure is the pl-sql block in precomplile from and can be used to excecute plsql statement


What government can declare public holidays?

federal government


Example for trigger creation in SQL server in 2000 and syntex for it?

please i want learn trigger and procedure but i don't know anything i know some commend in sql server can any person help me this is my email nassir_farhan1@yahoo.com


You created a stored procedure in sql server 2005 database and you called through aspnet page with connection then you are getting error as - Could not find stored procedure 'GetLoginInfo' solve pls?

The connections bruk.