Rickie is back .... 人生·工作的结果=思维方式×热情×能力

今天比昨天更好，明天比今天更好，为此，不屈不挠地工作、勤勤恳恳地经营、孜孜不倦地修炼，我们人生的目的和价值就是这样确确实实地存在着。

博客园 :: 首页 :: 新随笔 :: 联系 :: 订阅

:: 管理 ::

397 随笔 :: 3 文章 :: 1310 评论 :: 129 引用

12 2006 档案

SQL SERVER – 检测LOCK、终止会话 ID/UOW 的用户进程

摘要: KILL { session ID | UOW } [ WITH STATUSONLY ] 阅读全文

posted @ 2006-12-31 21:39 Rickie 阅读(1323) | 评论 (0) 编辑

SSB – Activation Execution Context

摘要: The problem is that the activation execution context is trusted only in the database, not in the whole server, like other stored procedures or DB. So when the activated SP calls another SP located in the other DB, the above exception will occur.阅读全文

posted @ 2006-12-28 18:19 Rickie 阅读(453) | 评论 (0) 编辑

SSB – Handling and Removing Poison Messages

摘要: A poison message is a message containing information that an application cannot successfully process. A poison message is not a corrupt message, and may not be an invalid request.阅读全文

posted @ 2006-12-28 16:14 Rickie 阅读(413) | 评论 (0) 编辑

SSB - Fire and Forget: Good for the military, but not for Service Broker conversations

摘要: the author suggests another pattern for SSB message conversation. The solution is let the target end the conversation first. The initiator can simply send the message to the target and then continue. The target will receive the message, end the conversation from the target side and this will send an EndDialog message back to the initiator. 阅读全文

posted @ 2006-12-27 23:24 Rickie 阅读(434) | 评论 (0) 编辑

SSB FAQ (4) – Debug tips for SSB beginners

摘要: There are some tips which are helpful for SSB beginners to debug and resolve some general issues.阅读全文

posted @ 2006-12-27 23:06 Rickie 阅读(390) | 评论 (0) 编辑

SSB FAQ (3) – A rowset provider OPENXML

摘要: OPENXML provides a rowset view over an XML document.
OPENXML SYNTAX:
OPENXML( idoc int [ in] , rowpattern nvarchar [ in ] , [ flags byte [ in ] ] )
[ WITH ( SchemaDeclaration | TableName ) ]

阅读全文

posted @ 2006-12-27 22:04 Rickie 阅读(331) | 评论 (0) 编辑

SSB FAQ (2) – Create a stored procedure as a service program

摘要: CREATE QUEUE [dbo].[Queue_OutStock_Out] WITH STATUS = ON , RETENTION = OFF ,
ACTIVATION
( STATUS = ON ,
PROCEDURE_NAME = [dbo].[usp_OutStock_OnReceiveMessage] ,
MAX_QUEUE_READERS = 5 , EXECUTE AS N'dbo'
)

阅读全文

posted @ 2006-12-27 21:35 Rickie 阅读(341) | 评论 (0) 编辑

SSB FAQ (1) – Target Queue cannot receive message

摘要: SSB target queue can not get a message, when the sender sends a message without any error.

阅读全文

posted @ 2006-12-27 18:53 Rickie 阅读(309) | 评论 (0) 编辑

How to generate an RSS feed for your web site using ASP.NET

摘要: RSS stands for "Really Simple Syndication", is a standardized, XML-formatted means for syndication Web site content.

Understand that RSS is intended to provide information about a Web site's latest content. For example, Yahoo! News provides RSS feeds of the latest news headlines, and TigerDirect.com provides RSS feeds of the feature items on the shopping site. Notice that RSS provides a synopsis for the recent articles or news items. It does not provide the complete content for all of 阅读全文

posted @ 2006-12-24 16:42 Rickie 阅读(422) | 评论 (2) 编辑

URL mapping – ASP.NET 2.0 New feature

摘要: URL mapping – ASP.NET 2.0 New feature阅读全文

posted @ 2006-12-23 20:43 Rickie 阅读(452) | 评论 (1) 编辑

SSB Exception - Sql Server 2005

摘要: SSB Exception - Sql Server 2005阅读全文

posted @ 2006-12-21 13:50 Rickie 阅读(565) | 评论 (1) 编辑

Using a SQL Adapter in BizTalk Server 2004

摘要: Using a SQL Adapter in BizTalk Server 2004阅读全文

posted @ 2006-12-19 19:29 Rickie 阅读(304) | 评论 (0) 编辑

Distinguished Fields vs. Promoted Properties in Biztalk

摘要: Distinguished Fields vs. Promoted Properties in Biztalk阅读全文