Sunday, September 16, 2012

To make ASP.NET 2.0 project which use ajax extensions work on Windows 2003 Server you need to install AJAX extensions first:

This is the correct version to use: ASP.NET AJAX 1.0 (file ASPAJAXExtSetup.msi)

You can download it here: http://www.microsoft.com/en-us/download/details.aspx?id=883

If you experience problems with ajax menu under IE9 like not working on hover you must also apply this patch:
NDP20SP2-KB981201-x86.exe

How to kill active connections in SQL Management Studio

To kill active connections in SQL Management Studio 2008 do this:

1. Right-click the server in Object Explorer and select 'Activity Monitor'.
2. When it opens, expand the Processes group.
3. Now use the drop-down to filter the results by database name.
4. Kill off the server connections by selecting the right-click 'Kill Process' option.

If you are using SQL Management Studio 2005 it's a good advice to upgrade management studio to 2008 as it works with latest MSSQL2005 server updates.