Re: ANSI_WARNINGS error in Stored Procedure

From: Noe Carranza (noech77_at_hotmail.com)
Date: 01/16/04

  • Next message: Anu: "Trouble granting access to user in MSDE-2000" 
    Date: Fri, 16 Jan 2004 13:53:51 -0800

    Hi Russell, thanks a lot for replying...

    you are correct, the linked server is a JDEdwards.

    I was trying to create the stored procedure from the New Stored
    Procedure Window, instead of the Query Analyzer. I dont know why I didnt
    try the Query Analyzer before.

    So there's a tip for all of you people, use the query analyzer and
    forget about problems. Thanks again Russell! :)

    Noe.

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!

  • Next message: Anu: "Trouble granting access to user in MSDE-2000"

    Relevant Pages

    • Re: Is sql server as good as access 97?
      ... Once you really get into using Query Analyzer for writing your ... Transact-SQL and for formulating 'queries' for exporting to your code, ... resulting stored procedure runs in a small fraction of the time it took to ... Unfortunately the database I am converting ...
      (microsoft.public.sqlserver.programming)
    • RE: Differences in execution times for a stored procedure
      ... If OleDb, ... "Vincent Keller" wrote:> I am trying to execute a time-consuming stored procedure in my application. ... > Are there some known performance differences in executing a query directly through Query Analyzer and through ADO.NET? ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: "On Error Resume Next" in SQL Server
      ... When you are running your query in query analyzer, ... > would occur would be due to bad user input which does not ... > that my stored procedure will run to the end of the cursor? ...
      (microsoft.public.sqlserver.programming)
    • Re: Exception: The SqlTransaction has completed; it is no longer usabl
      ... > I hv encountered this exception 'The SqlTransaction has completed; ... returning around 9000 rows in a DataSet and back to the app. ... > When that exception is thrown, I tried running the same stored procedure ... > I was thinking if Query Analyzer can return data very quickly... ...
      (microsoft.public.dotnet.framework.adonet)
    • ADO vs Query Analyzer Performance -- Its not parameter sniffing
      ... Immediately calling the same stored procedure WITH SAME PARAMETERS from ... Query Analyzer returns the results almost immediately. ... Analyzer call returned very quickly (40 seconds from app, ... ADO/SQLOLEDB interaction with SQL Server is different than Query Analyzer. ...
      (microsoft.public.data.ado)