"Lock time out exceeded" when make fulltext index

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

"Lock time out exceeded" when make fulltext index

Author

Topic

johnvm
Starting Member

18 Posts

Posted - 2007-09-01 : 02:54:01

Hey guys, I get the error when trying to create a full text index:

quote:
TITLE: Full-Text Indexing Wizard Progress
------------------------------
Create full-text index failed.
Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1406&EvtSrc=MSSQLServer&EvtID=1222&LinkId=20476

http://support.microsoft.com/?id=308518 which Microsoft touts as the solution to my problem, doesn't particularly offer a solution to this issue.

Any ideas? This is happening whilst using the Management Studio Full-Text Indexing Wizard.

johnvm
Starting Member

18 Posts

Posted - 2007-09-01 : 03:25:58

Fixed - had to restart MSSQL service 4x. Odd error. Dunno the cause. Seems resolved now though.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources