Archive

Send MSMQ message from SQL Server

2007-05-03 08:19:19 by Kjell-Åke Gafvelin

I got a question from a customer if there was any solution to send a message via MSMQ from SQL Server. After some searching I found two different solutions to the problem. The first solution is to install a extended procedure (XP_MSMQ) and the second is to modify the security settings for System.Messaging and use the CLR integration in SQL Server. 

|

What happened to Windows Live Writer???

2007-05-08 12:50:22 by Kjell-Åke Gafvelin

I have been using Windows Live Writer for quite a while to update this blog. But what happened to it? Their blog is practically dead since it hasn't been updated since November 2006.

|

Map Oracle Datatypes to .NET Datatypes

2007-05-08 14:50:02 by Kjell-Åke Gafvelin

In my current project we have been using Oracle as a database. And we have been quite sloppy with defining the correct datatypes for integers and decimals, we have just been using the Oracle datatype NUMBER without specifying precision or scale for both. So I thougth I would create a list with the correct values for precision and scale for integer, decimal, single e.t.c.

  • Int16 = NUMBER(4,0)
  • Int32 = NUMBER(9,0)
  • Int64 = NUMBER(18,0)
  • Single = NUMBER( < 8, < 44)
  • Double = NUMBER( < 16, *)
  • Decimal = NUMBER(*,*)

|

MSMQ Studio 0.7.3.0

2007-05-09 06:31:35 by Kjell-Åke Gafvelin

In this version I have only fixed so that it is now possible to delete messages from a queue.

MSMQ Studio

|

MSMQ Studio 0.7.4.0

2007-05-13 23:26:45 by Kjell-Åke Gafvelin

While the family is sleeping I decided to add two more features to MSMQ Studio.

  • Copy messages between queues
  • Set autorefresh rate for message list view

MSMQ Studio

|

MSMQ Studio 0.7.5

2007-05-15 12:43:23 by Kjell-Åke Gafvelin

Fixed so that the body of the message is also copied when copying messages.

|