.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

How to read Search index using SQL

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#
 

Hi,

Where does the search index data get stored in sharepoint ? Is it in the index file location or in the SQL database ? Is it possible to read the index data using SQL queries ?




View Complete Post


More Related Resource Links

Ingest google Search Index into Sharepoint 2007

  

Hi Folks

 I am wondering  if there is a way to ingest google search index into SharePoint index such that when people search via SharePoint they see the Google results too… incorporated/federated inline with the SP results (not as a separate "box" ).

We have Google search in our environment and also share-point search. Share-point search for sharepoint site but Google search is for all other environments. Now i am thinking if we ingest the Google search index into share-point then may be its great deal to provide user a platform to search everything on one place.

 

thanks

ws


i am at entry level administrator

QueryEx (Search) results and Custom Page Index

  

Hi All,

I done a web part which allow the user to query the search.asmx. It return the result fine against which I apply some xslt. However I need a mean to create a Page index. I only return the result based on a range defined in the query.

I need somehow to obtain the number of result the search is returning in total against what I only want to display on the screen.

The only way I sort of figure to do that is by first make a search just to obtain the number of result it will return in total and then make a search defining a range.

Has someone done something similar?

Seve


If the index write count is more than index read count should it be dropped ?

  
If the index write count is more than index read count should it be dropped ?   i am using this query to see thank you for all answers SELECT object_name(s.object_id) AS 'Table Name', i.name AS 'Index Name', i.index_id, user_updates AS 'Total Writes', user_seeks + user_scans + user_lookups AS 'Total Reads', user_updates - (user_seeks + user_scans + user_lookups) AS 'Difference' FROM sys.dm_db_index_usage_stats AS s WITH (NOLOCK) INNER JOIN sys.indexes AS i WITH (NOLOCK) ON s.object_id = i.object_id AND i.index_id = s.index_id WHERE objectproperty(s.object_id,'IsUserTable') = 1 AND s.database_id = db_id() AND user_updates > (user_seeks + user_scans + user_lookups) AND i.index_id > 1 ORDER BY 'Difference' DESC, 'Total Writes' DESC, 'Total Reads' ASC;     and here sample result please comment it for me   http://img688.imageshack.us/img688/527/indexim.png  Best of Pokemon Games PokemonCraft Developer Used URL rewriting at it's Pokedex

Backup failed for Object Shared Search Index failed in event OnBackup.

  
Hi, Farm level backup completed with 2 errors on SharePoint server 2007 through STSADM command line. Error details: Error: Backup failed for Object Shared Search Index failed in event OnBackup. For more information, see the error log located in the backup directory. Error: Object Shared Search Index failed in event OnPrepareBackup. For more information, see the error log located in the backup directory.     WebException: The current operation timed-out after 3600 seconds. Debug:    at Microsoft.Office.Server.Search.Administration.SearchSharedApplication.Microsoft.SharePoint.Administration.Backup.IBackupRestore.OnPrepareBackup(Object sender, SPBackupInformation args)    at Microsoft.SharePoint.Administration.Backup.SPBackup.RunPrepareBackup(SPBackupRestoreObject node) Error: Object Shared Search Index failed in event OnBackup. For more information, see the error log located in the backup directory.     Object Shared Search Index failed in event OnPrepareBackup. For more information, see the error log located in the backup directory.     WebException: The current operation timed-out after 3600 seconds     WebException: The current operation timed-out after 3600 seconds [26/08/2010 14:23:44]: Debug:    at Microsoft.Office.Server.Search.Administration.SearchSharedApplication.Microsof

Can i use Windows desktop search indexing service to index a full sql database ?

  

Hi

i wonder if i can use the windows indexing service to perform indexing on a database instead of file system ?

i.e we need to use the windows indexing service to create index table that contains information from all rows in the database

 

thanks


Sharepoint Search Server Express 2008 can not index external domain fileshare with valid account

  

Since i have understood that sharepoint 2008 search express doesn't do any security trimming i am trying to index an external fileshare (on a non trusted domain) with it. After authenticating with the external domain account I can manually access all the files in that share i need to. Sharepoint 2008 search express somehow is unable to use the crawl rule in which i specified a different content access account (which is the external domain account).It continuously gives the error "Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content."

Exactly the same configuration works fine with sharepoint search server 2010, but that does do security trimming and because of the share being completely external my users could't see any search results.

Any suggestions?



QueryEx (Search) results and Custom Page Index

  

Hi All,

I done a web part which allow the user to query the search.asmx. It return the result fine against which I apply some xslt. However I need a mean to create a Page index. I only return the result based on a range defined in the query.

I need somehow to obtain the number of result the search is returning in total against what I only want to display on the screen.

The only way I sort of figure to do that is by first make a search just to obtain the number of result it will return in total and then make a search defining a range.

Has someone done something similar?

Seve


Search for Clustered Index in database on varchar, nvarchar column

  

Hi,

I have very big database, i am running a Re-index job and it's keep failing throwing everyday error stating "Online index operation cannot be performed on clustered index as index contains column of data type text, nvarchar.

is there any way i can search and change all such datatype of culstered into non-clustered indexes or any better solution i have.


Backup problem on SP 2007 - Shared search index

  

I am having a problem that I really can't figure out, and have found -nothing- online.

 

When I run a backup (from Central Admin or stsadm) it hangs just after trying to start the Shared Search Index, as seen from the log below:

Code Snippet

 

[8/28/2007 1:06:53 PM]: Verbose: Starting object: Shared Search Index.
[8/28/2007 2:07:25 PM]: Error: Object Shared Search Index failed in event OnPrepareBackup. For more information, see the error log located in the backup directory.
 WebException: The current operation timed-out after 3600 seconds
[8/28/2007 2:07:25 PM]: Debug:    at Microsoft.Office.Server.Search.Administration.SearchSharedApplication.Microsoft.SharePoint.Administration.Backup.IBackupRestore.OnPrepareBackup(Object sender, SPBackupInformation args)
   at Microsoft.SharePoint.Administration.Backup.SPBackup.RunPrepareBackup(SPBackupRestoreObject node)
[8/28/2007 2:07:25 PM]: Verbose: Starting object: sharepoint_company_MOSS_search.

 

 

A little bit

How can I stop MOSS search services without deleting the index?

  

We want move our search database to a different drive on the same database server.  In order to do this, we need all the SharePoint things that would connect to that database to be off.  I see there is an stsadm command for stopping search but it looks like this would have the same effect as using the Central Admin site--it would basically be the equivalent of uninstalling it.  While I realize it is easy to uninstall and reinstall, the index of crawled content is pretty big and it would take some time to rebuild the index completely.

Short of shutting down the SharePoint farm while we make the database move, how can you stop the SharePoint services that connect to the search database? 

If we stop all of the app pools and all of the windows services related to SharePoint, will this accomplish the objective?  So far at this point, it seems to me that the safest way to handle this would be to simply shut down the farm servers while we do the db maintenance and restart them when it is done.


How to read Contextual Search scopes programmatically?

  

Hi,

I have a requirement where I am trying to code a custom Search control. I am using the code snippet mentioned at http://www.learningsharepoint.com/2010/07/28/programatically-get-search-scopes-for-search-service-application-sharepoint-2010/ to read the Search scopes.

However this gives the Shared search scopes. I am not able to read the contextual search scopes using these API's.

Can anyone help me o how to ready the contextual search scopes "This Site" and "This List" in SharePoint 2010?

Thanks!


-http://lrathi.blogspot.com

Trying to read PerformanceCounter getting : Could not read Category Index ####

  
We have a monitoring application that along with other things monitors PerfCounters on various servers.
The application spawns multiple processes to execute the monitoring tasks. One of the monitoring tasks is to collect PerfCounter data from remote machines using the System.Diagnostics.PerformanceCounter class. The code seems to work fine for the most part but intermittently fails with the following error
          
            Could not read Category Index ####

We verified that the systems being monitored are not clusters (with active/passive nodes failing over etc). Also these counters are standard Exchange or SQL counters that should not be changing on the machine.
I read this post about some caching that the .net framework does under the cover that may be related but not sure.
Any pointers that you might have on this would be very helpful.
Thanks
Sham

New index server, not seeing any search results

  

I recently added an index server to our farm (MOSS 2007, 1 WFE, 1 SQL) and split up indexing and querying duties between the new server and old WFE.  Everything appears to be functioning normally, I see no errors in the event logs, all service accounts are the same as before, but if I try and do a search I get no results returned.  I have been running crawls (current crawl time is 10 hours and counting) but if I look it says that there are 0 items in the index.  I am also getting nothing in the crawl log.  No errors, no warnings, nothing.  I'm stumped without any errors as to what might be the cause.  Search was working fine before I added the new box.  Any help would be appreciated.


MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

SharePoint Gets Search Analytics

  
Microsoft's SharePoint Portal Server 2003 was sold into a large number of organizations based solely on the strength of the search tool. Organizations hungered for a way to find the data they had generated.

Using SharePoint Search feature in ASP.Net Application

  
Integrating ASP.Net application in to MOSS 2007 to utilize SharePoint Enterprise Search Feature can be done by using Business Data Search.

Get more then google search from here

  
Just make it home page and enjoy more then google search you not only get google result and prizes for searching but also free ebooks and link from here like orkut,facebook,twitter,yahoomail etc...

Thanks
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend