Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Phoenix130481

    Can't Connect to 2003 Server

    Maybe try http:\\<ip>\<ProjectName>\<indexpage>
  2. Phoenix130481

    In Database Output Window no result.

    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...
  3. Phoenix130481

    Table Name as Parameter?

    Hello, does anyone know whether it is possible that i can pass a Parameter as a Variablename? except if then else construct! Thanks, Basti
  4. Phoenix130481

    AutoIncrement in a Column?

    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
  5. Phoenix130481

    EXECUTE privilege not compatible with a object,

    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
  6. Phoenix130481

    EXECUTE privilege not compatible with a object,

    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 ;)
  7. Phoenix130481

    EXECUTE privilege not compatible with a object,

    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...
  8. Phoenix130481

    EXECUTE privilege not compatible with a object,

    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...

Part and Inventory Search

Back
Top