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 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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,
  4. 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