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 2008 Forums  SQL Server Administration (2008)  Reclaim Memory After FullText Catalog Execution On

Author  Topic  Sheeraz Starting Member 4 Posts Posted - 2009-06-24 : 09:13:56 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?