Hi all,

I have deleted all the index and now it is working fine.

I need to recreate all and again I have to check.

Log size is normal.

How to check the statistics?

Dear Friends,

Thank you a lot for your support.

I will try to use it.

Dear Friends,

Thank you a lot for your support.

I will try to use it.

Dear Friends,

Thank you a lot for your support.

I will try to use it.

Dear Mohit,

Thank you for your reply.

Can you tell me how to do the same with the both ways?

Thank you a lot in advance.

Dear Ken,

Thanks a lot for your timely help.

It was working when, I am altering the database as you said and then using the master database, then I issued the drop...

Dear Friends,

Thanks a lot :).

The script what "krayknot" has given is working fine and that's what I need too.

Thanks a lot for all of us who has replied and helped...

Dear Friend,

OOps, I want to perform search in the data in the columns of all the tables not the column names.

When the user gives 'sample' then I have to search...

Dear Friend,

Thank you for the assistance.

But I have to do if from the front end so I want an option to exectue a procedure such that it will replicate the...

Dear All,

Thanks for you replies.

I have the table which contains some properties of the document in my knowledge repository.

The user can search by specifying any values to the properties.

Based on...

Dear Friend,

Thank you for your reply.

🙂

Dear Friends,

Below is my code:

[font="Arial"]CREATE PROCEDURE [dbo].[vsp_SearchDocuments1]

/****************************************************************************************/

--Name: vsp_SearchDocuments1

--Desc: To search the knowledge base

/****************************************************************************************/

-- Add the parameters for the stored procedure here

@vcextn varchar(max),

@biguserID bigint

AS

BEGIN

--Declare variable for Dynamic Table Name

--Set NoCount On

...

Dear Friends,

Thank you all for your efforts.

Already I have the function in order to split the string to tabular values from this site.

Now in the front end I just extracted...

Dear Friend,

Thank you a lot it is working.

Thank you so much.

Best Regards,

M. J. Jaya Chitra