Although it can be listed from an .udl file, I think it also has to be
registerd in the SQL Server registry, becase the SELECT query is run from
SQL server.
The second argument format is correct. I think it might be a COM issue. You
can try to post this in a COM newsgroup.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
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)
