Archive for April, 2007

How to Manually Update System Tables – SQL Server 2000

Tuesday, April 17th, 2007

This tip comes with a warning: You can cause serious and ireparable damage by updating system tables if you do the wrong thing – use this tip at your own risk! If you find yourself in the position of needing to update one of the system tables in SQL Server 2000, this tip may help […]

How to Truncate Log Files – SQL Server 2000

Monday, April 16th, 2007

If you have been in the position of supporting SQL Server and having to move database backups around at any point, you have probably become aware of how troublesome large log files can make the process. This article is intended to offer you a quick solution to the problem. Prior to commencing any work on […]

How to Automatically Create a Sitemap & Google Sitemap

Monday, April 16th, 2007

As a web designer one of the corner stones of every good website is a well maintained sitemap. Maintaining a web-site’s sitemap however can be difficult; particularly where the content is frequently updated. A tool we frequently use at Techita to help reduce this burden is Audit My PC’s Google Sitemap Generator. This tool will […]