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.

Thursday, March 17, 2011

Google Chrome Session Manager Extension Move

If you are using this helpful extension I want to share how to move your current saved sessions to another computer. The sessions are stored in "Local Storage" which is simply SQLite local file. The default location under Vista/Windows 7 is here:
C:\Users\YourUser\AppData\Local\Google\Chrome\User Data\Default\Local Storage\chrome-extension_bbcnbpafconjjigibnhbfmmgdbbkcjfi_0.localstorage
So you need to close Google Chrome and then replace this file in the same directory on the other computer.

Update: Here is how you can find the actual path of the local storage file: Hit the right mouse button over the extension icon and choose Manage. Then you can see the actual ID of the extension which corresponds to the name of the file:
Here is the local file at C:\Users\YourUser\AppData\Local\Google\Chrome\User Data\Default\Local Storage\:

Tuesday, March 9, 2010

How to set default website to ASP.NET 2.0


The following will set the default website to ASP.NET 2.0:
C:\windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -sn W3SVC/
Child applications inherit the ASP.NET setting from the parent, so all children will have the new setting.

Remote connection to MSSQL server on a specific port

If you use specific port (not 1433 by default) for MSSQL server remote connections, then when you want to connect trough SQL Server Management you must specify the new port in server name with comma, e.g.:
Server name: www.yourserver.com,3281

Friday, February 8, 2008