When you run a full-text query in SQL Server 2000 while a catalog merge operation also occurs, the result set may not return quickly. When this delay occurs, the SQL Server User Mode Scheduler (UMS) may stop responding. Additionally, you may experience stalled worker request behavior.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help