This is a discussion on Queue handling design pattern? within the SQL Server forums, part of the Microsoft SQL Server category; --> B D Jensen (bjorn.d.jensen@gmail.com) writes: > I now looked a little more at SB, it seems a bit complex ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| B D Jensen (bjorn.d.jensen@gmail.com) writes: > I now looked a little more at SB, it seems a bit complex for this type > for this purpose (=> much more code than I had written in my > solution)... > ... but I probably should read more so I fully understand what it can > give... Since I don't know your application in detail, I cannot say whether Service Broker is right nor. But since you said "queue", it was natural to mention Service Broker. In any case, I think it is a good idea to get acquainted with Service Broker, because even if you don't use it this time, you will sooner or later run into a case where you will find it useful. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |