Hello i am try to use the following stored Procedure:
ALTER PROCEDURE DuplikateErmitteln
@Var1 int,
@Var2 int,
@Var3 int OUTPUT
AS
SELECT @Var3 = Matrikel
FROM UserMM
WHERE Matrikel = @Var2
IF @Var3 != @Var2
RETURN @Var3
ELSE
RETURN @Var2
RETURN
maybe it looks confusing...
Hello,
does anyone know whether there is a possiblity to insert a auto-value as a identifier?
E.g.: Whenever i insert a value, the ID is incremented?
Thanks Basti
Hello,
i could solve the problem! the problem was GRANT EXEC ON UserMM TO OpaDBUser!! UserMM is the Table, OpaDB the user...very strange!! does anyone has a explanation for this?!
Basti
This is strange, when i use the server explorer in Visual Studio it does work...so i guess it must be a programming error somewhere inside my program.
SQLBrother ;)
This is what i wrote!
StoredProceduresInsertStudenten is the SP,
OpaDBUser is the User,
UserMM is the Table i want to insert the Data
Grant Execute On StoredProceduresInsertStudenten To OpaDBUser
Grant SELECT, INSERT, DELETE, UPDATE, REFERENCES on UserMM To OpaDBUser
amd below you can see the...
Hello,
as you can see above i get this message when i want to start a stored procedure. i have grant the execute right to the stored procedure but i get then this error. below you can see the full error message:
ystem.Data.SqlClient.SqlException: Das erteilte oder aufgehobene EXECUTE-Privileg...
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.