SQL Server 2008 - Neuron ESB User Network2024-03-29T00:44:41Zhttp://forum.neuronesb.com/forum/topics/sql-server-2008?commentId=2748813%3AComment%3A985&feed=yes&xn_auth=noAs far as I know, there is no…tag:forum.neuronesb.com,2009-07-10:2748813:Comment:10232009-07-10T17:25:54.000ZFrostyhttp://forum.neuronesb.com/profile/Frosty
As far as I know, there is nothing "out of the box" as far as making message audits more queryable (I have already made that request).<br />
<br />
But given that, I THINK SQL 2008 might provide a better embedded CLR experience. I have been thinking about trying to create a read-only view of the audit tables that would use CLR integration to break apart the message field into separate columns. I do not know if this is even possible (but it should be, if it isn't).<br />
<br />
Taking this approach, should not cause…
As far as I know, there is nothing "out of the box" as far as making message audits more queryable (I have already made that request).<br />
<br />
But given that, I THINK SQL 2008 might provide a better embedded CLR experience. I have been thinking about trying to create a read-only view of the audit tables that would use CLR integration to break apart the message field into separate columns. I do not know if this is even possible (but it should be, if it isn't).<br />
<br />
Taking this approach, should not cause any Neuron internal errors, and at the same time open the door for more useful (searchable) audit investigation.<br />
<br />
Just my $0.02<br />
<br />
I would be willing to collaborate. Is there an advantage to usin…tag:forum.neuronesb.com,2009-07-10:2748813:Comment:10212009-07-10T17:06:03.000Zkris mattsonhttp://forum.neuronesb.com/profile/krismattson
Is there an advantage to using 2008 vs. 2005? I can't seem to find a use for the data in 2005 becase messages aren't queryable because they are sored in a binary format.
Is there an advantage to using 2008 vs. 2005? I can't seem to find a use for the data in 2005 becase messages aren't queryable because they are sored in a binary format. Good news / Bad news.
If you…tag:forum.neuronesb.com,2009-06-25:2748813:Comment:9852009-06-25T01:01:45.000ZFrostyhttp://forum.neuronesb.com/profile/Frosty
Good news / Bad news.<br />
<br />
If your machine is already set up to converse with SQL Server 2008 then all appears to work, but have only scratched the surface.<br />
<br />
If your machine has NOT been setup to interact with SQL Server 2008, then there appears to be missing SS2008 assemblies. Our clean machine could not query or create stored procedures via ESB Explorer.
Good news / Bad news.<br />
<br />
If your machine is already set up to converse with SQL Server 2008 then all appears to work, but have only scratched the surface.<br />
<br />
If your machine has NOT been setup to interact with SQL Server 2008, then there appears to be missing SS2008 assemblies. Our clean machine could not query or create stored procedures via ESB Explorer.