Sql Server Faq http://www.sqlserverfaq.net Learn Sql Server through my Experience Sun, 15 Aug 2010 11:40:54 +0000 http://backend.userland.com/rss092 en Transactional Replication in SQL 2008 Fails “The distribution agent failed to create temporary files in ‘C:\Program Files\Microsoft SQL Server\100\COM’ directory. System returned errorcode 5.” http://www.sqlserverfaq.net/2010/08/15/transactional-replication-in-sql-2008-fails-the-distribution-agent-failed-to-create-temporary-files-in-cprogram-filesmicrosoft-sql-server100com-directory-system-returned-errorcode/ Fragmentation should not be the only factor which decides the Rebuild Index http://www.sqlserverfaq.net/2010/06/28/fragmentation-should-not-be-the-only-factor-which-decides-the-rebuild-index/