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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gam101

  1. gam101

    Extremely odd remote stored procedure behavior.....Please Help!

    Here is some more info. on SQL command preparation by Microsoft..... http://technet.microsoft.com/en-us/library/ms130779%28SQL.100%29.aspx
  2. gam101

    Extremely odd remote stored procedure behavior.....Please Help!

    Just wanted to update this thread about a possible solution. It turns out that the "sp_prepexecrpc" statement that "prepares" the SQL command for execution was actually being sent by my remote app. So, essentially, any SQL preparation is now disabled & the Profiler does not show any trace of...
  3. gam101

    Extremely odd remote stored procedure behavior.....Please Help!

    @ Crowley16 Thank you for the prompt reply. No, I have not checked permissions because as I mentioned in the post, sometimes the remote procedure does execute successfully. And when I execute it using the Query Analyzer from a Server's client with the "EXEC" statement, it is always...
  4. gam101

    Extremely odd remote stored procedure behavior.....Please Help!

    Greetings! Please help me with the following extremely odd stored procedure behavior on MS. SQL Server 2000. I have a stored procedure that is executed remotely. When it is executed in our office test environment, the Profiler shows a perfect sequence of execution & return of results. However...
See more

Part and Inventory Search

Back
Top