Articles

Affichage des articles du janvier, 2012

ASP.NET fails to detect IE10 causing _doPostBack is undefined JavaScript error or maintain FF5 scrollbar position

Image
There is a bug in the browser definition files that shipped with .NET 2.0 and .NET 4, namely that they contain definitions for a certain range of browser versions. But the versions for some browsers (like IE 10) aren't within those ranges any more. Therefore, ASP.NET sees them as unknown browsers and defaults to a down-level definition, which has certain inconveniences, like that it does not support features like JavaScript. The following fixes solve the browser-detection issue forever for all sites on a machine. These will be rolled up into future versions of the framework and will eventually also be on Windows Update. .NET 4 - http://support.microsoft.com/kb/2600088 .NET 2.0 http://support.microsoft.com/kb/2600100 for Win7 SP1/Windows Server 2008 R2 SP1, Windows Vista/Server 2008, Windows XP/Server 2003 http://support.microsoft.com/kb/2608565 for Win7/Windows Server 2008 R2 RTM [EDIT] If you don't want to install those hotfixes on a production sys

SQL Server Database Mail - How to clear the queue

Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine. Using Database Mail, your database applications can send e-mail messages to users. The messages can contain query results, and can also include files from any resource on your network. Database Mail is designed for reliability, scalability, security, and supportability. If your Database Mail suddenly stops working then you can try to clear the mail queue and restart the service manually. Unfortunately, there is no function in Management Studio in order to perform this task. These procedures are presented in a logical order: 1.  Stop SQL Server Agent (otherwise, the queue will be locked) Start SQL Server management Studio Connect to your SQL Server Right-click on SQL Server Agent Choose Stop 2. Click on New Query 3. Empty the mail queue by typing the following statement (then press F5 to execute) msdb.dbo.sysmail_delete_mailitems_sp 4. Once the queue i