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.
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.
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(*,*)
In this version I have only fixed so that it is now possible to delete messages from a queue.
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
Fixed so that the body of the message is also copied when copying messages.