Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Linked Server   (RSS)

Query to the SYSTEMINDEX to read the Microsoft search results fails when using Search.CollatorDSO provider

We can query the results from the Microsoft search through SQL server. If we create a linked server with Search.CollatorDSO provider and try to query the SYSTEMINDEX to read the Microsoft search results. We get an error in SQL server 2008 Below is the Read More...
Posted Thursday, August 27, 2009 2:36 PM by sanjayap | 0 Comments

In SQL Server 2008, the product name and the data source information goes blank in "Linked server properties" window

In SQL Server 2008, sometimes the product name and the data source information goes blank in Linked server properties window for a Linked server of provider type Microsoft OLEDB provider for SQL Server or SQLOLEDB . When we create a Linked Server of type Read More...
Posted Sunday, August 23, 2009 6:28 PM by sanjayap | 0 Comments

Did you know... Accessing Linked server using Synonym can fail with an error 7359

Accessing Linked server using Synonym results in an error after we rebuild Indexes on the target server in SQL Server 2005. The Error Message is like below, Msg 7359, Level 16, State 1, Line 1 The OLE DB provider "SQLNCLI" for linked server "Domain\User" Read More...
Posted Tuesday, September 23, 2008 7:15 PM by sanjayap | 1 Comments
 
Page view tracker