I have a server that has 16 Gigs RAM and having Windows 2003
Enterprise Server with SQL Server 2008 Enterprise Edition Sp2.
Now I have 6 FullText Catalogs each approx. size of 2 GB, and I use them separately
from different stored procedures and I am not executing stored procedures simultaneously.
Now I want to know that is there any way i reclaim the memory which is
occupied by Fulltext Catalog before executing second stored procedure?