A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

How to fix creating index (Full-Text catalogs) – Error 229 (Permission denied) in SQL Server?

Symptoms:\r\nI have my development database on a SQL Server 2005 server. I enabled it for full-text catalogs and created a catalog with no issues whatsoever. When I go to create the index, however, I run through the wizard (using SQL Server Management Studio) until the last step. Upon finishing the wizard, I get the following […]

Backup IIS7 ApplicationHost.config and Settings


Internet Information Services 7 (IIS7) doesn’t use metabase-like file from IIS6. Instead the settings and configuration are stored in schema files and applicationHost.config files.\r\n\r\nSince the configuration files are different, the old IIS6 tools will not be able to backup IIS7 settings.\r\n\r\nThis is the new script that you can use to backup your IIS7 web […]

How to change SQL Server database collation



\r\n\r\nIf you tried changing collation to from English to Turkish or other using the script as below but it will fail due to dependencies issues, You have to script them, drop them, change db collation and recreate them from script.\r\n\r\nThe Collation change script:\r\n





Recover SQL Server Database from Suspect Mode

To recover database from suspect mode in SQL Server 2005 / 2008 use this script in MS SQL Server management Studio:\r\n\r\nEXEC sp_resetstatus ‘yourDBname’;\r\nALTER DATABASE yourDBname SET EMERGENCY\r\nDBCC checkdb(‘yourDBname’)\r\nALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE\r\nDBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS)\r\nALTER DATABASE yourDBname SET MULTI_USER\r\n\r\nNote: change ‘yourDBname’ with database name you want to recover from suspect mode.

Arabic Language Shows ??? in Smartermail Web interface


Problem: When someone send email through smartermail web interface anything with Arabic Language shows ????. Is this SM related or something we need to set server side?\r\n\r\nSolution: This can be controlled at the User’s Inbox through Settings > My Settings > Account Settings >> Compose. Set the Text Encoding to “Unicode (UTF-8)” (“Arabic (ISO)” […]

How to enable Full text search in SQL Server 2008

In this article we will describe to create Full text search in SQL Server 2008 through SQL Server management studio. To create a full-text catalog:\r\n


Launch SQL Server management studio 2008


Connect to SQL Server


In Object Explorer, expand the server, expand Databases, and expand the database in which […]

Rhythmbox – A Tool to Sync Android Smartphones Using Linux

Interest levels in synchronize music collections have notched up a bit of late with the introduction of a plethora of new Android-based super phones. That is, unless you happen to be one of those owners with a large quantity of digital music encumbered by digital rights management (DRM) also known as copy protection. For this […]

Page 4 of 9« First...23456...Last »