Enable Fulltext gives Timeout...any ideas why?

• Dennis-509860

  Old Hand

  Points: 351

  More actions

  April 14, 2008 at 11:43 pm

  #128609

  Any idea why this would give a timeout?

  declare @catalog_exists int;

  SELECT @catalog_exists = isnull(fulltextcatalogproperty('My fulltext', 'ItemCount'),-1);

  if @catalog_exists = -1 begin

  exec sp_fulltext_database 'enable';

  exec sp_fulltext_catalog 'My fulltext', 'Create';

  end;

  THANK YOU!

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  April 15, 2008 at 7:18 am

  #802543

  While it is running, run the procedure sp_who2 and make sure no processes are blocking it.

  DDL changes can get blocked by other processes pretty easily.