随笔分类 - S.SQLServer2005
SQL Server 2005
摘要：There are some tips which are helpful for SSB beginners to debug and resolve some general issues.
阅读全文
摘要：OPENXML provides a rowset view over an XML document.
OPENXML SYNTAX:
OPENXML( idoc int [ in] , rowpattern nvarchar [ in ] , [ flags byte [ in ] ] )
[ WITH ( SchemaDeclaration | TableName ) ]
阅读全文
摘要：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'
)
阅读全文
摘要：SSB target queue can not get a message, when the sender sends a message without any error.
阅读全文
摘要：SSB Exception - Sql Server 2005
阅读全文
摘要：Database Engine Tuning Adviser: How to tune your new SQL Server 2005 This article shows you how to tune your new SQL Server 2005 by using Database Engine Tuning Advisor. SOURCE URL:http://searchsqlse...
阅读全文
摘要：Microsoft SQL Server 2005 Setup FAILED! TITLE: Microsoft SQL Server 2005 Setup------------------------------There was an unexpected failure during the setup wizard. You may review the setup logs and/o...
阅读全文
摘要：Source Link: http://www.aspnetresources.com/blog/sql_cache_depedency_overview.aspx....................Configuring SQL Cache Dependency (Sql Server 7 and 2000)There’s some manual configuration of web.c...
阅读全文
摘要：Error: 'Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.'Keywords: SQL Server 2005/SQL Server Express, Re...
阅读全文
摘要：Multiple Active Result Sets (MARS) is a new feature of ADO.NET 2.0 that provides the capability to open more than one result set over the same connection and lets you access them all concurrently. Prior to MARS, each result set required a separate connection. Currently, the first commercial database to support MARS is SQL Server 2005.
阅读全文
摘要：这里演示同一个SQL Server中不同数据库之间的基于Service Broker的异步消息传递，其中Stored Procedure充当Service Program。
阅读全文
摘要：Conversation Endpoints can be looked up via querying the sys.conversation_endpoints catalog view in the local broker's database. In this way, we continue on a demo to check Conversation Endpoints in both the Initiator and Target Endpoints.
阅读全文
摘要：Following the previous post, A simple tutorial on SQL Server 2005 Beta 2 Service Broker, this post will handle how to send messages to and from in the different Database or SQL Server.
阅读全文
摘要：Service Broker is a new technology in Microsoft SQL Server 2005 Beta 2 that helps database developers build secure, reliable, and scalable applications. Service Broker provides queuing and reliable messaging as part of the Database Engine. These features provide the infrastructure necessary to build high-performance applications that easily scale-up or scale-out.
阅读全文
摘要：SQL Server 2005 webcast Series [English]
阅读全文
摘要：SQL Server 2005对SQL Server 2000而言，总体感觉各个方面均很大的提升。因为短短试用了几天，简单记录一下自己的体验。
阅读全文
