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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: sujal
  • Order by date
  1. sujal

    asp.net :Execute permission denied on object 'SprocName'

    Thanks. How can I grant this on all objects on the DB
  2. sujal

    asp.net :Execute permission denied on object 'SprocName'

    I don't remember granting any permission when I created the Sproc. How to enable that now? Also it should allow only 'Windows authenticated users' who access the system and not public.
  3. sujal

    SQL server - Permission issues : Execute permission denied on object '

    I have an ASP>NET application that uses Integrated Windows authentication. My Web.config looks like below <add key="dbconnection" value=" server=XXX;Initial Catalog=XXX;persist security info=False;Integrated Security=SSPI;Pooling=true" /> When users try to access my application, they get the...
  4. sujal

    asp.net :Execute permission denied on object 'SprocName'

    I have an ASP.NET application that uses Integrated Windows authentication. My Web.config looks like below <add key="dbconnection" value=" server=XXX;Initial Catalog=XXX;persist security info=False;Integrated Security=SSPI;Pooling=true" /> When users try to access my application, they get the...
  5. sujal

    Stored proc to execute on a different SQL SERVER

    How to have a linked server from the server. Also how should I refer to tables in my proc? Thanks
  6. sujal

    Stored proc to execute on a different SQL SERVER

    Can I write a procedure that should connect to a different SQL server and execute a series of SELECT statement on that SQL SERVER. Reason being is I do not have permission to create procedure on that destination server while I have permission to execute a SELECT statement. Please clarify Thanks,
  7. sujal

    Output paramter not fetched after ExecuteNonQuery() method

    Thanks a lot. I am just in the initial phase and hence will change my DB design. This should help me eliminate the issue I am facing right now
  8. sujal

    Output paramter not fetched after ExecuteNonQuery() method

    I tried return earlier. It does not go well with varchar types :-( Another quick question : Is it better to have the Id column in a table (ex: studentid) as a Identity datatype or as a char datatype ( to have ids like S1,S2 etc...). I have so many master tables in my DB and have to maintain...
  9. sujal

    Output paramter not fetched after ExecuteNonQuery() method

    I'm Sorry. But ExecuteNonQuery() returns number of affected rows while I want the OUTPUT param from procedure. Here is how my procedure looks like: CREATE PROCEDURE dbo.GenerateRowids @TableName varchar(50), @ColumnName varchar(50), @rowidval varchar(30) output AS Begin declare @sql...
  10. sujal

    Output paramter not fetched after ExecuteNonQuery() method

    I have a STORED PROC for dynamic T-SQL that returns a OUTPUT varaible of typevarchar . This works fine in query analyzer. But when I try to get values in asp.net page it does not return anything. No execeptions or errors also. HDConn = CommonMethods.BuildConnection(); SqlCommand cmd1 = new...

Part and Inventory Search

Back
Top