Blog / Mssql

How to check the progress of the ‘Shrink Database’ task in SQL Server 2005

August 15, 2009

My first blog post in a long time!

So I archived some data from our database yesterday and I needed to shrink the database file so I ran the “Shrink Database” task in Management Studio. The database is over 500GB in size and I checked 7 hours later and the database shrink operation is still going. I got a little worried because someone needs to use this database today and I’m not sure if the …

Can’t connect to SQL Server 2005 using PHP

October 21, 2008

I was updating our web application last Friday and I needed it to connect to an SQL Server 2005 Express Edition database to query some tables but my application couldn’t connect to the MSSQL server.

After a few hours of searching the internet and trying different things I finally got it to work by downloading a newer version of ntwdblib.dll (version 2000.80.194.0) and replacing the one that came with PHP 5.2 (we’re using WAMP (Windows, …

How to query a Microsoft Office Access database from SQL Server

September 6, 2008

I was doing this yesterday to query our call logs which are stored in an Access database. I figured it would be really nice to be able to query our databases from one application. The software that came with our phone system to generate reports from the call logs is also not that flexible. It’s just much easier for me to run reports using SQL Server Query Analyzer plus we can join the tables from …