The dot net framework provides us a way to compress and decompress data using the classes under the System.IO.Compression. There are two main classes that perform the job, namely the GZipStream class and the DeflateStream class.
By default, SQL Server 2005 doesn’t allow remote connection so you have to enable it manually. This article shows you how to enable remote connection in your SQL Server 2005.