I am developing an English Query module as part of a web-based system.
I am using ASP code from the MSEQ sample that comes with SQL Server to
obtain the SQL statement generated by the engine. I then run this query
and display the results.
My problem is that sometimes, the function (ProcessResponse) returns
only a piece of the required query, instead of the entire query. For
example, if the query generated consists of a series of SELECT INTO
#Test statements and the last one is a simple select statement that
outputs the final result, all the engine outputs is the last SELECT
statement. Since this returned query picks data from temp tables which
do not exist, I just keep getting errors which I cannot solve right
now.
Any ideas on why the entire query is not getting returned? Help! Hard
to explain this to the users!
Re: CONTAINS performance ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization,...SQL Server tables. ... (microsoft.public.sqlserver.fulltext)
Re: Indexing Service, Openquery and sp_executesql ...SQL Server version and sp are you running? ... > data from the indexing service catalog when pasted into ... > query analyzer, but failed when put against sp_executesql ... I would choose Microsoft Indexing... (microsoft.public.sqlserver.fulltext)
Re: Problem using Access or Query Designer to run queries in SQL Serve ... >or Query Designer within Enterprise Manager, it works and I get data back. ... >ODBC Call Failed [ODBC SQL Server Driver] Timeout Expirederror in Access ...>[ODBC SQL Server Driver] Timeout Expired ... (microsoft.public.sqlserver.odbc)
Extreme performance issues (SQL Server 2000/ADO.NET/C#) ... This process runs very quickly if run through Query... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ... (microsoft.public.dotnet.framework.adonet)
Re: Transaction Isolation Level ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ... (comp.databases.ms-sqlserver)
