Thanks Lynn, I will try it out.

I still hope someone can give me some clues on the xp_regread thing.

Thanks!

Thanks for the reply Lynn! So what you suggested is to remove this:

SELECT @spidstr=coalesce(@spidstr,',' )+'kill '+convert(varchar, spid)+ '; '

FROM master..sysprocesses WHERE dbid in (db_id('SampleDB1'), db_id('SampleDB2'))

and leave this in the stored...

noggin, thanx for the reply!

The error message just simply "the statement is terminated". Anyhow, I got it working yesterday. I found out that one column contains duplicated values when I...

but is it a good idea to change the timeout value?

Actually, am I doing the right thing by importing the large chuck of data from the XML to the database? Any other way to do this?

Thanks very much for all the replies.

Brian, I am new to SQL Server, can you tell me what do you mean by moving up the nodes and what is the...

Thank you for all your help!

Russell, I used the 'nolock' in the SELECT statement and now the database is back to its optimal execution time. Thanks for the tip!!

Okee, it seems that the long execution time has nothing to do with the search function, it might have something to do with my new table and code that I...

Thanks for the reply Allen,

Do you think changing the SQL statement to stored procedure would help?