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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How to exclude xml tags from fulltext search?

Posted By:      Posted Date: October 01, 2010    Points: 0   Category :Sql Server
We have an XML string stored in an ntext column (one tag being named "<Fields>", along with some string values. In doing a CONTAINS query, I found that searching on "Fields" returns every record in the table. So I added the string <Fields> to a custom stoplist and attached it to the fulltext index, but now the index doesn't contain any values for "Fields", either. (must be ignoring the brackets) Is there a way to exclude "<Fields>" without excluding "Fields"?

View Complete Post

More Related Resource Links

How to exclude xml tags from fulltext search?

We have an XML string stored in an ntext column (one tag being named "<Fields>", along with some string values, in a table with a fulltext index. In doing a CONTAINS query, I found that searching on "Fields" returns every record in the table. So I added the string <Fields> to a custom stoplist and attached it to the fulltext index, but now the fulltext index doesn't contain any values for "Fields", either. (must be ignoring the brackets) Is there a way to exclude "<Fields>" without excluding "Fields"?

Exclude the author name from the search results



How can i prevent author's name to appear in search results. shows many results when i search the "author.name".

I want, MOSS 2007 Search get results from the content only the user sees.


Is data mining techniques better than using fulltext , soundex , pattern to search records? heres my

<!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0; mso-font-charset:2; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:0 268435456 0 0 -2147483648 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} p {mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} /* List Definitions */ @list l0 {mso-list-id:27487746; mso-list-template-ids:77652700;} @list l0:level1 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l1 {mso-list-id:297423348; mso-list-type:hybrid; mso-list-template-ids:1760099356 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;} @list l1:level1 {mso-level-tab-stop:66.0

Remove "I like It" , "Tags & Notes" , RecycleBin and the default search box

Hello Is it possible to remove the "I like It" and "Tags & Notes" buttons? , the default "Search this site..." box in the top? And Recycle Bin... I want to remove/hide it so we cant see it on any of our websites. Thanks in advice...

Search not crawling Tags?

I created a Word document in a library and then added a tag.  I did a full crawl and the tag that I created is not bringing the document up in the search results.  How do I make the search crawl all content?

SQL 2008 FullText Search will not Start



I have installed, uninstalled and installed again MS-SQL 2008 Enterprise on my system. The installation seems to go OK. I used "Select ALL" when I was choosing which components to add. I saw "FullText Search" in that list and it WAS checked for installation.

I'm going through one of those Training Kits (70-433) and I need to install the example databases. One of them "AdventureWorks" requires Full Text Search to install.

I can see "SQL Server FullText Search" in the list of services on my control panel. It's startup type is "Automatic" but it is NOT started. I attempt to start it and I get a message window saying the it could not start it: "Error 3: The system cannot find the specified path."

When I select the FullText Search and look at its Properties, under the "General Tab", I find that the "Path to Executable" is completely empty.

I have no idea what the command line string should look like or even what the name of the execuatble should be.

I have been rooting through the WEB looking for solutions to this problem. One forum I read said that the file name that I am looking for is MSFTESQL.EXE. I have searched my entire harddrive. That files is NOT THERE. I DID find a file called MSFTE.EXE.

This has been going one for some time. I h

SQL Server 2008, SQLMetal and FullText Search


My Sproc:

ALTER PROCEDURE [dbo].[SP_SearchTopics]
	@keywords varchar(512) = '""'
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.

	SELECT t.*, FTT_T.RANK as 'Rank'
	FROM Topic t
	INNER JOIN FREETEXTTABLE(Topic, [Name], @keywords) as FTT_T ON t.ID = FTT_T.[KEY]

When I run sqlmetal on my database, I get this error: 

Warning : SQM1014: Unable to extract stored procedure 'dbo.SP_SearchPosts' from SqlServer. Null or empty full-text predicate.

I tried checking the @keywords parameter for null and empty string, but that doesn't work.  Any ideas guys?

Slow fulltext search



I have a problem with full text search. It runs very slow. Originaly I thought that our server doesn't have enough memory to cache full text catalog and has to read it from the disk every time. But I ran single containstable statement on the server and it returned results instantly. So I guess the problem is in joining containstable results with other tables, Views.  I understand that containstable runs separately and the query is passed to MS Search Engine which returns results to SQL and merges them with the rest of the query. But I am not able to figure out what exactly causes the entire query to slow down. I also noticed that Order By rank desc slows down performance even further. But I need to show most relevant results first. Also, similar query without containstable works quite well. Below is the simplified version of my query along with the execution plan. Please help me to understand/solve this problem. We have SQL 2005 Workgroup edition, Windows 2003 server Standard edition. 4GB ram. Database size 55GB. Full text catalog size 600 Mb.


select top 60 
rn = ROW_NUMBER() OVER (ORDER BY key_tbl.rank desc),
productslocation_pid, min(ProductsLocation_price) minprice,
max(ProductsLocation_price) maxprice, count(*) BCNT, rank
from containstable (products, txtcat, 'video') as key_tbl
inner j

Unable to perform fulltext search for documents in some folders in an SharePoint Document Library


Issue Description : Keywords from certain folders in the Document Library  is not searchable via full text search. For example, the keyword “4MB7106” is not searchable, even though the document is available in the document library. This is content search in a file in a document library, NOT a file name. Any ideas?

how to exclude folders(and items within this folder) under document library in search result?

I have a library with a particular content type. I also have a folder _thumbs within it. I do not want the search to retrieve the items that are within this folder (or the folder for that matter). Any ideas on how this can be achieved?
Sharepoint Dummy

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...


Adding Search Refinements in SharePoint 2010

I have been playing around with SharePoint 2010 Search this morning. I love the new UI. The search refinements panel is just begging to be messed with. In my case I wanted to add the file extension JPG as an Image Type refiner.

Search Engines and Multilanguage Websites - using .resx


I have a website (asp.net 3.5+c# +linq ) having thopition to change languages (2) by the user, Am using the search engine like in the example of:


this search will find any searched word in all the pages and return the link in the default language of the site, but problem for the second language , because by default the site language is English and the user have the option to change to other language.

and as I understood that the .resx files can not be searched like the aspx by the search engines.

I looked in many blogs and discussion boards for similar  case but unfortunately no clues on this issue .
The only same case posted :


and also I could not find any clue to move on, 

 Kindly requsted to guide me for the soultio

Thanks for your time and wish you all the best
your help is always appreciated


how to make a dropdownlist looks like google search box


dear all...

any idea how to do that ?

Thnx in advance

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