Category Archives: sql

Use Apache, PHP, and MSSQL on Windows

Posted on April 28, 2010 by Blake

This is how I made the php_mssql extension work on my Windows/Apache/MSSQL/PHP (WAMP) Server. Download Apache. (I used the Win32 Binary including OpenSSL 0.9.8m (MSI Installer)) Download PHP. (I used the PHP 5.2.13 zip package) Download ntwdblib.dll.   Run the … Continue reading →

Posted in apache, php, sql, windows | Comments Off on Use Apache, PHP, and MSSQL on Windows

Recover SQL Server from ‘Suspect’ Status

Posted on March 30, 2010 by Blake

Last night, I had a power outage and a SQL Server went down. When I rebooted it, the database was in ‘Suspect’ mode. After some quick googling I found a solution. [code lang=”sql”] EXEC sp_resetstatus ‘yourDBname’; ALTER DATABASE yourDBname SET … Continue reading →

Posted in sql | Comments Off on Recover SQL Server from ‘Suspect’ Status