Mr. 50, thanks for your time. Your given solution does not have any parameters and whichi is what i am looking for. If you read this whole post you will...

being busy in other tasks i did not get chance to see fix for this. Anyone help me in this. seems the post goes far from gurus for help.

Shamshad Ali.

yes you are right Mr. 500

here is my sample code, it should return proper groups Ids, A is parent of all sub groups B and B is parent of B1...

Hello chrisM@home,

There is one scenario in which the query is not returning me expected data when there is no any Parent exists in groupAssociation table like follows:

CREATE TABLE [dbo].[groupAssociations](

...

Thank you very much for your help.

my final function now looks as follows:

Alter FUNCTION [dbo].[GetAllSubGroupsByList]

( ...

Thanks, the given code works with sample code now. I have a question, why we are limiting it to lr.Level < 8?

does that means we are drilling down to 7th...

Many thanks that someone tried to resolve my problem. I have been looking for replies since i posted my question. The result is incorrect because when A is part of...

Thanks, is there anyway to make a single query? For depending on parameter we put Cade in where clause

Where domain is not null or empty and domain like '%my domain.com%'...

I have removed all words and the file is empty since beggining of my editing/testing to fix this issue without any luck.

Shamshad Ali.

Yes, I have re-started the server also and I am sure about the noise text file as i have taken that file location from registry as mentioned in my post.

Shamshad...

Thanks alot. Your help and sharing knowledge is highly appreciated ...

Shamshad Ali.

yes, its working now. Thanks

1- What are the pros & cons of this change?

2- Should I remove the stopList which is StopWith as mentioned above? or it is...

SQL Server 2008 (100) R2 Enterprise Edition.

I re-build the fulltext index

alter fulltext index on SearchLookup

set stoplist StopWith;

where StopWith is the stopList name and i have added "with" as stop...

I used stopList and added keyword "with" but no luck, then i removed it and now there is no any stopList on my FullText stop list.

Shamshad Ali.

Could you plz. tell me how do you get stats using profiler? what events and their columns to choose in profiler? plz. write in detail.

Shamshad Ali.