Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DaveC11
Starting Member
43 Posts |
 Posted - 2009-03-11 : 12:32:08
|
| Hi I'm having massive problems with a sp i created. I made a full-text text index on two tables and created the below sp. I had tested bot the full-text index and sp on a tast server and everything ran fine. Now when I try to alrer, delete or run the sp I get a lock request time out error. Can some please help me!?ALTER procedure [dbo].[sp_leap29_jobdetails_QuickSearch2] (@Keyword nvarchar(500),@Location nvarchar(500)) as select distinct j.jobid, j.jobtitle, convert(varchar(11),j.createdon, 106) as date, aa.description as 'location', left(cast(j.publishedjobdescription as Nvarchar(500)), 300)+ ' ....' as 'Description', j.createdon, cast(round((j.maxbasic),2,1) as decimal(10))as 'salary' From jobattributes a join Jobs j on j.jobid = a.jobid join attributes aa on aa.attributeid = a.attributeid where CONTAINS(aa.description,@location) and contains((j.jobtitle,j.publishedjobdescription),@keyword) and aa.attributemasterid in ('419') and j.updatedon > dateadd(month,-6,getdate()) and DATALENGTH(publishedjobdescription) > 100 |
|
|
|
|
|
|
|
lock request timeout period exceeded - when runnin