Posts Tagged scheduled maintenance
Full Text Reindex, scheduled job has no steps!
Posted by shawson in SQL Server on January 12th, 2010
We have a SQL Server 2005 box, on which we have a database which has a full text index. The database gets a massive refresh of its data each night, meaning the full text index needs rebuilding. I added a schedule to my full text index (Databases > [DBName] > Storage > Full Text Catalogs > Right click your index – click properties > Population Schedule) and this created me a new job (SQL Server Agent > Jobs) but when i opened it up and went to steps, nothing was there! If i tried running the job it would fail because there are no steps!
I found this as a documented bug in the initial release candidate of sql 2005 (since fixed in the service packs) on the microsoft connect site, and added a workaround – basically just add your own job, using the following sql (which i found on msdn) to rebuild your index;
ALTER FULLTEXT CATALOG [catalogue_name] REBUILD;
Of course, this is only a workaround until we can get the latest service pack installed.
-
Flexicoder Blog- Free icons website August 25, 2010Great site for sets of free icons that can be used in your apps http://webtreats.mysitemyway.com/ Social Bookmarking […]
- Localisation language names August 2, 2010When creating a new localisation file Xcode expects you to supply the correct name for the file, the list of valid values is here Social Bookmarking […]
- CFBundleiconfile does not have an extension July 28, 2010Currently there is an issue with Apples Application Loader, although the documentation states that you can omit the file extension from the Icon File name, and this works when running locally, when you come to submit it to the app store it fails validation. At the moment you have to specify the names using the CFBundleIconFiles Social [...] […]
- Truly quit app under iOS4 July 3, 2010Great article that explains how to terminate your app so that it doesn’t go into suspend mode, basic details are here Multi-tasking can be great, but it has added some complexity to programming on the iPhone. For many apps there really is no advantage. For instance, does the “That’s What She Said” button really need [...] […]
- iOS4 EXEC_BAD_ACCESS with setHidesBottomBarWhenPushed June 24, 2010Raised the following bug with Apple, (Id 8126566) Get EXEC_BAD_ACCESS when hiding a bottom bar that doesn’t exist Steps to Reproduce: SettingsViewController* settings = [[SettingsViewController alloc] init]; [settings setHidesBottomBarWhenPushed:YES]; [self.navigationController pushViewController:settings animated:YES]; [settings release]; The active […]
- SQL Server 2008 – Table Valued Parameters June 16, 2010Here is a great article that explains how to use TVP’s via .Net and a stored procedure Social Bookmarking […]
- Free icons website August 25, 2010