<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://weblogs.asp.net/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Omar AL Zabir blog on ASP.NET Ajax and .NET 3.5 - All Comments</title><link>http://weblogs.asp.net/omarzabir/default.aspx</link><description>Working hard to enrich millions of peoples' lives</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP1 (Debug Build: 20510.895)</generator><item><title>re: ASP.NET Ajax Extender for multi-column widget drag &amp; drop</title><link>http://weblogs.asp.net/omarzabir/archive/2007/10/22/asp-net-ajax-extender-for-multi-column-widget-drag-amp-drop.aspx#7248356</link><pubDate>Fri, 06 Nov 2009 15:26:35 GMT</pubDate><guid isPermaLink="false">c06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:7248356</guid><dc:creator>Kishore Mouli</dc:creator><description>&lt;p&gt;I was looking this type of code from long time.&lt;/p&gt;
&lt;p&gt;I have added couple of other bits to work with data grids and grid views.&lt;/p&gt;
&lt;p&gt;Regards,&lt;/p&gt;
&lt;p&gt;Novel Kishore Mouli Padeti&lt;/p&gt;
&lt;img src="http://weblogs.asp.net/aggbug.aspx?PostID=7248356" width="1" height="1"&gt;</description></item><item><title>re: ASP.NET Ajax Extender for multi-column widget drag &amp; drop</title><link>http://weblogs.asp.net/omarzabir/archive/2007/10/22/asp-net-ajax-extender-for-multi-column-widget-drag-amp-drop.aspx#7245678</link><pubDate>Tue, 03 Nov 2009 04:46:22 GMT</pubDate><guid isPermaLink="false">c06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:7245678</guid><dc:creator>oazabir</dc:creator><description>&lt;p&gt;Sorry I am no longer maintaining this. I have been using jQuery Drag &amp;amp; Drop and the Sortable plugin for this. Please check the latest Dropthings code how it is used. jQuery is more powerful and easier to use than an AJAX Extender.&lt;/p&gt;
&lt;img src="http://weblogs.asp.net/aggbug.aspx?PostID=7245678" width="1" height="1"&gt;</description></item><item><title>re: Simple way to cache objects and collections for greater performance and scalability</title><link>http://weblogs.asp.net/omarzabir/archive/2009/11/01/simple-way-to-cache-objects-and-collections-for-greater-performance-and-scalability.aspx#7245676</link><pubDate>Tue, 03 Nov 2009 04:08:32 GMT</pubDate><guid isPermaLink="false">c06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:7245676</guid><dc:creator>RazanPaul</dc:creator><description>&lt;p&gt;Thanks for sharing…………………&lt;/p&gt;
&lt;img src="http://weblogs.asp.net/aggbug.aspx?PostID=7245676" width="1" height="1"&gt;</description></item><item><title>re: ASP.NET Ajax Extender for multi-column widget drag &amp; drop</title><link>http://weblogs.asp.net/omarzabir/archive/2007/10/22/asp-net-ajax-extender-for-multi-column-widget-drag-amp-drop.aspx#7245557</link><pubDate>Tue, 03 Nov 2009 00:04:38 GMT</pubDate><guid isPermaLink="false">c06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:7245557</guid><dc:creator>Sergio</dc:creator><description>&lt;p&gt;First of all I want to thank and congratulate for this excelent project.&lt;/p&gt;
&lt;p&gt;After a week with hands on it I could make it work even with an error message that says: Error creating control (Could not load file or assembly System.Web.Extensions, Version=1.0.61025.0 ....)&lt;/p&gt;
&lt;p&gt;This little problem is a brick on the way when I want to work on Design mode cause the elements inside the Update Panel cannot be seen.&lt;/p&gt;
&lt;p&gt;Second I'd like to share a change I made that I could take a better behavior but still not that one we can see on IGoogle/Dropthings. If anyone could help I woul aprecciate:&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;_repositionDropCue : function(data)&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;{&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;var location = Sys.UI.DomElement.getLocation(data.item);&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;var nearestChild = this._findItemAt(location.x, location.y, data.item);&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;var el = this.get_element(); &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;if( null == nearestChild )&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;el.removeChild(this._dropCue);&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;el.insertBefore(this._dropCue,el.firstChild);&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;else&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;if( nearestChild.previousSibling != this._dropCue )&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;el.removeChild(this._dropCue);&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;el.insertBefore(this._dropCue, nearestChild); &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;} &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;},&lt;/p&gt;
&lt;img src="http://weblogs.asp.net/aggbug.aspx?PostID=7245557" width="1" height="1"&gt;</description></item><item><title>Simple way to cache objects and collections for greater performance an</title><link>http://weblogs.asp.net/omarzabir/archive/2009/11/01/simple-way-to-cache-objects-and-collections-for-greater-performance-and-scalability.aspx#7244922</link><pubDate>Mon, 02 Nov 2009 04:08:03 GMT</pubDate><guid isPermaLink="false">c06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:7244922</guid><dc:creator>WebDevVote.com</dc:creator><description>&lt;p&gt;You are voted (great) - Trackback from WebDevVote.com&lt;/p&gt;
&lt;img src="http://weblogs.asp.net/aggbug.aspx?PostID=7244922" width="1" height="1"&gt;</description></item><item><title>SQL Server DBA Blog &amp;raquo; A significant part of sql server process memory has been paged out. This may result in a performance degradation.</title><link>http://weblogs.asp.net/omarzabir/archive/2007/10/19/a-significant-part-of-sql-server-process-memory-has-been-paged-out-this-may-result-in-performance-degradation.aspx#7241427</link><pubDate>Wed, 28 Oct 2009 12:41:30 GMT</pubDate><guid isPermaLink="false">c06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:7241427</guid><dc:creator>SQL Server DBA Blog » A significant part of sql server process memory has been paged out. This may result in a performance degradation.</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;SQL Server DBA Blog &amp;amp;raquo; A significant part of sql server process memory has been paged out. This may result in a performance degradation.&lt;/p&gt;
&lt;img src="http://weblogs.asp.net/aggbug.aspx?PostID=7241427" width="1" height="1"&gt;</description></item><item><title>re: 7 tips for for loading Javascript rich Web 2.0-like sites significantly faster</title><link>http://weblogs.asp.net/omarzabir/archive/2009/09/23/7-tips-for-for-loading-javascript-rich-web-2-0-like-sites-significantly-faster.aspx#7233127</link><pubDate>Mon, 19 Oct 2009 17:32:58 GMT</pubDate><guid isPermaLink="false">c06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:7233127</guid><dc:creator>umar</dc:creator><description>&lt;p&gt; hi Omar it's a pleasure to meet u, my name is Umar from Nigeria.&lt;/p&gt;
&lt;p&gt;I have been given a project to build a widget. Please I need more detailed explanation.umarmujahid24@yahoo.com&lt;/p&gt;
&lt;img src="http://weblogs.asp.net/aggbug.aspx?PostID=7233127" width="1" height="1"&gt;</description></item><item><title>re: 7 tips for for loading Javascript rich Web 2.0-like sites significantly faster</title><link>http://weblogs.asp.net/omarzabir/archive/2009/09/23/7-tips-for-for-loading-javascript-rich-web-2-0-like-sites-significantly-faster.aspx#7229799</link><pubDate>Wed, 14 Oct 2009 15:23:20 GMT</pubDate><guid isPermaLink="false">c06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:7229799</guid><dc:creator>Enigma</dc:creator><description>&lt;p&gt;Hi Omar ,&lt;/p&gt;
&lt;p&gt;I am Web and Windows applications developer. I Think , i have enough expertise to produce any application. but at this time i don't have any order for create application . i am working in myself company and i will not want to work in other companies. &lt;/p&gt;
&lt;p&gt;Do You Think, witch options is better than other one ?&lt;/p&gt;
&lt;p&gt;option one :&lt;/p&gt;
&lt;p&gt;first :create a product&lt;/p&gt;
&lt;p&gt;second : Find customer for produced product&lt;/p&gt;
&lt;p&gt;option two :&lt;/p&gt;
&lt;p&gt;first : Find customer and implement him order&lt;/p&gt;
&lt;p&gt;Do you know any new idea to create new product ?&lt;/p&gt;
&lt;p&gt;Thanks lot&lt;/p&gt;
&lt;img src="http://weblogs.asp.net/aggbug.aspx?PostID=7229799" width="1" height="1"&gt;</description></item><item><title>re: Optimize ASP.NET Membership Stored Procedures for greater speed and scalability</title><link>http://weblogs.asp.net/omarzabir/archive/2009/03/14/optimize-asp-net-membership-stored-procedures-for-greater-speed-and-scalability.aspx#7223973</link><pubDate>Tue, 06 Oct 2009 10:40:18 GMT</pubDate><guid isPermaLink="false">c06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:7223973</guid><dc:creator>Aamir Hasan</dc:creator><description>&lt;p&gt;if you have mulitple application runing then /*Modilfy by aamir Hasan*/&lt;/p&gt;
&lt;p&gt;/*Date :06-05-2009 &amp;nbsp; */&lt;/p&gt;
&lt;p&gt;/***web Team(Dev)***/&lt;/p&gt;
&lt;p&gt;set ANSI_NULLS ON&lt;/p&gt;
&lt;p&gt;set QUOTED_IDENTIFIER OFF&lt;/p&gt;
&lt;p&gt;GO&lt;/p&gt;
&lt;p&gt;ALTER PROCEDURE [dbo].[aspnet_Profile_GetProperties]&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;@ApplicationName &amp;nbsp; &amp;nbsp; &amp;nbsp;nvarchar(256),&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;@UserName &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; nvarchar(256),&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;@CurrentTimeUtc &amp;nbsp; &amp;nbsp; &amp;nbsp; datetime&lt;/p&gt;
&lt;p&gt;AS&lt;/p&gt;
&lt;p&gt;BEGIN&lt;/p&gt;
&lt;p&gt;/**/&lt;/p&gt;
&lt;p&gt;	 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;DECLARE @ApplicationId uniqueidentifier&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;SELECT &amp;nbsp;@ApplicationId = NULL&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;SELECT &amp;nbsp;@ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;IF (@ApplicationId IS NULL)&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;RETURN&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;DECLARE @UserId uniqueidentifier&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;SELECT &amp;nbsp;@UserId = NULL&lt;/p&gt;
&lt;p&gt;	DECLARE @LastActivityDate datetime&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;SELECT @UserId = UserId, @LastActivityDate = LastActivityDate&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;FROM &amp;nbsp; dbo.aspnet_Users&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;WHERE &amp;nbsp;ApplicationId = @ApplicationId AND LoweredUserName = LOWER(@UserName)&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;IF (@UserId IS NULL)&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;RETURN&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;SELECT TOP 1 PropertyNames, PropertyValuesString, PropertyValuesBinary&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;FROM &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; dbo.aspnet_Profile&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;WHERE &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;UserId = @UserId&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;IF (@@ROWCOUNT &amp;gt; 0)&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;BEGIN&lt;/p&gt;
&lt;p&gt;			IF DateDiff(n, @LastActivityDate, @CurrentTimeUtc) &amp;gt; 60&lt;/p&gt;
&lt;p&gt;		BEGIN&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;UPDATE dbo.aspnet_Users&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SET &amp;nbsp; &amp;nbsp;LastActivityDate=@CurrentTimeUtc&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;WHERE &amp;nbsp;UserId = @UserId&lt;/p&gt;
&lt;p&gt;			END &lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;END&lt;/p&gt;
&lt;p&gt;END&lt;/p&gt;
&lt;img src="http://weblogs.asp.net/aggbug.aspx?PostID=7223973" width="1" height="1"&gt;</description></item><item><title>re: Optimize ASP.NET Membership Stored Procedures for greater speed and scalability</title><link>http://weblogs.asp.net/omarzabir/archive/2009/03/14/optimize-asp-net-membership-stored-procedures-for-greater-speed-and-scalability.aspx#7222398</link><pubDate>Sat, 03 Oct 2009 17:00:07 GMT</pubDate><guid isPermaLink="false">c06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:7222398</guid><dc:creator>Aamir Hasan</dc:creator><description>&lt;p&gt;www.studentacad.com&lt;/p&gt;
&lt;p&gt;Aamir Hasan&lt;/p&gt;
&lt;p&gt;ALTER PROCEDURE [dbo].[aspnet_Profile_GetProperties]&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;@ApplicationName &amp;nbsp; &amp;nbsp; &amp;nbsp;nvarchar(256),&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;@UserName &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; nvarchar(256),&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;@CurrentTimeUtc &amp;nbsp; &amp;nbsp; &amp;nbsp; datetime&lt;/p&gt;
&lt;p&gt;AS&lt;/p&gt;
&lt;p&gt;BEGIN&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;-- 1. Please no more locks during reads&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;DECLARE @ApplicationId uniqueidentifier&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;--SELECT &amp;nbsp;@ApplicationId = NULL&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;--SELECT &amp;nbsp;@ApplicationId = ApplicationId FROM dbo.aspnet_Applications &lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;WHERE LOWER(@ApplicationName) = LoweredApplicationName&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;--IF (@ApplicationId IS NULL)&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;-- &amp;nbsp; &amp;nbsp;RETURN&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;-- 2. No more call to Application table. We have only one app dude!&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;SET @ApplicationId = dbo.udfGetAppId()&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;DECLARE @UserId uniqueidentifier&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;DECLARE @LastActivityDate datetime&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;SELECT &amp;nbsp;@UserId = NULL&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;SELECT @UserId = UserId, @LastActivityDate = LastActivityDate&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;FROM &amp;nbsp; dbo.aspnet_Users &lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;WHERE &amp;nbsp;ApplicationId = @ApplicationId AND LoweredUserName = LOWER(@UserName)&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;IF (@UserId IS NULL)&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;RETURN&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;SELECT TOP 1 PropertyNames, PropertyValuesString, PropertyValuesBinary&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;FROM &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; dbo.aspnet_Profile&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;WHERE &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;UserId = @UserId&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;IF (@@ROWCOUNT &amp;gt; 0)&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;BEGIN&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;-- 3. Do not update the same user within an hour&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;IF DateDiff(n, @LastActivityDate, @CurrentTimeUtc) &amp;gt; 60&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;BEGIN&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;-- 4. Use ROWLOCK to lock only a row since we know this query&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;-- is highly selective&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;UPDATE dbo.aspnet_Users WITH(ROWLOCK)&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SET &amp;nbsp; &amp;nbsp;LastActivityDate=@CurrentTimeUtc&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;WHERE &amp;nbsp;UserId = @UserId&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;END&lt;/p&gt;
&lt;p&gt; &amp;nbsp; &amp;nbsp;END&lt;/p&gt;
&lt;p&gt;END&lt;/p&gt;
&lt;img src="http://weblogs.asp.net/aggbug.aspx?PostID=7222398" width="1" height="1"&gt;</description></item></channel></rss>