Category: Database

0

Shrink log size in sql database

To shrink the file size I use the following script: Use DBName Go exec sp_dboption DBName, ‘trunc. log on chkpt.’, true checkpoint DBCC SHRINKFILE (N’DBNameFileName, 0); exec sp_dboption DBName, ‘trunc. log on chkpt.’, false






0

How to enable 32-bit web server on 64-bit IIS

C:\>cscript C:\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1 C:\>cd windows\microsoft.net\framework\v2.0.50727 C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis.exe -i C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>NET STOP W3SVC /y & NET START W3SVC ERRORS: Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’ [Microsoft][ODBC Driver Manager] The specified DSN contains...






0

PHP Frameworks

PHP Framework PHP4 PHP5 MVC Multiple DB’s ORM DB Objects Templates Caching Validation Ajax Auth Module Modules EDP Akelos   – ash.MVC   – – – – – – CakePHP   – – CodeIgniter   – – –...






0

asp page export to EXCEL

<% FileName=”MyExcel.xls” response.ContentType = “application/vnd.ms-excel” response.AddHeader “content-disposition”, “inline; filename=” & FileName %>






0

Abyss Web Server – a free/great IIS subtitution

Abyss Web Server is a compact web server available for Windows, Mac OS X, Linux, and FreeBSD operating systems. Despite its small footprint, it supports HTTP/1.1, secure SSL/TLS connections (HTTPS), dynamic content generation through...