Howtos / Articles

Increase the IIS 6 maximum request length for ASP pages

A default installation of IIS 6 on a Windows machine (Server or workstation) will limit the maximum request size for ASP scripts to 200kb. This may not cause any issues for most users, however when you start to integrate file uploads and similar functions, you may find that you encounter this issue. A common ASP error that occurs when the limit is set too low is “‘ASP 0104 : 80004005′ Operation not Allowed”. Luckily this limit is easy to change,…

Read more [...]

Enable Apache Rewrite module on Ubuntu 10.04

By default, Ubuntu 10.04 doesn’t enable the rewrite engine module after installing Apache. The rewrite engine for Apache allows for on-the-fly URL rewriting/changing. This allows for the use of urls that are human readable, and SEO friendly. The rewrite engine is capable of capturing a website request, running it through a series of expression checks, and if a match is found, it will pass on the rewritten request to the web server. The end user would not notice anything different…

Read more [...]

Enable TCP/IP in Microsoft SQL Server 2005

When Microsoft SQL Server 2005 is first installed, you may find that by default the TCP/IP connection protocol is disabled. This was introduced with SQL Server 2005 to try and prevent future worms & virus from spreading around the internet on vulnerable systems. While this is a good thing, if the server is behind a firewall, and will never need to be accessed from the internet, you will find that having TCP/IP disabled may prevent some applications from connecting to…

Read more [...]

List all Triggers on a SQL Database

Ever wanted to know what triggers exist on a database? The script below will produce a list of all the triggers on the current database, and also what table they are linked to.   SELECT Name AS TriggerName, OBJECT_NAME(parent_object_id) AS TableName FROM sys.objects WHERE type=’TR’    …

Read more [...]



Page 38 of 38« First...1020...29303132333435363738