Thanks for the tip, but given this:

"The MSXML parser uses one-eighth the total memory available for SQL Server. To avoid running out of memory, run sp_xml_removedocument to free up the...

venoym (9/2/2014)

---

By the way, XQuery is tons slower than OPENQUERY when you need to shred unknown XML elements. I was assured that the XML was well formed by adding...

Hi again Venoym,

Could I get your advice on an appropriate fix?

The functionality behind this service broker implementation is to log messages occuring from remote sites. Basically the remote sites log...

Thanks heaps Venoym,

When Craig mentioned conversations, I had a gut feeling the answer was going to be something like that, but didn't have enough experience with Service broker to know...

Hi Craig,

Thanks heaps for the discussion. Don't bust your balls in getting an answer back, currently the messaging is running fine in production, the small batches are not causing...

Here is the script

IF NOT EXISTS(SELECT * FROM sys.schemas where name = 'ServiceBroker')

EXEC ('CREATE SCHEMA [ServiceBroker]')

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ServiceBroker].[SessionConversations]') AND type in (N'U'))

DROP TABLE...

Evil Kraig F (8/28/2014)

---

Just doublechecking. I've seen odd uses of things before and I hate making assumptions, so I tend to ask a lot of clarifying questions. Saves...

Hi mate,

Seeing as how no one else wants to bite at this. I'll have a go.

You haven't mentioned how you manage your servers, e.g. How do you know...

Yes, the Receive command is only used against Service Broker queues.

The primary key on the internal storage for columns is object_id (of the table) and columnid (which is an incrementing number) and only unique for that object_id.

Similarly the internal storage...

Or if you just want the numerical database size, you could just use

SELECTdatabase_name = db_name(),

database_size = (convert(DECIMAL(15, 2), sum(size))) * 8192 / 1048576

FROM sys.database_files ...

Thanks Jack,

I couldn't see the parameter list in the Update node properties, but the Option (RECOMPILE) did the trick.

Thanks for the cue, I'll read up on bad parameter...

I have since implemented the above methodology into our procedure and trigger writing, but have yet to do any testing, I am however confident that it will fulfil our needs.

If...

No worries Jeff,

Sorry for my narkyness earlier, I was somewhat frustrated by the situation. :ermm:

Hopefully this will help lots of others, this solution will become "best practice" within our...

🙂 I'm glad I'm not the only one going through this pain!

Yeah, I agree with you mate, I only wanted to suppress it because I couldn't come up with another...