Viewing 15 posts - 1 through 15 (of 71 total)
Thanks for the detailed explanation. In this case it looks like our only options are to upgrade the server or refactor the application calls...
July 7, 2012 at 8:10 am
Thanks, David.
Do you have a preference of one over the other?
June 29, 2012 at 5:04 pm
Thanks for answering this question. Does consulting also play a role? I would think that with the level of expertise required for an evangelist position, there would be a great...
June 25, 2012 at 10:48 am
Is it possible the table had a column dropped? Or an update to a previously wide column that made it smaller?
You can duplicate the problem this way:
USE tempdb
GO
IF...
June 14, 2012 at 1:29 am
Here is another sample which will allow you to get the header, trailer, and body data for each row of XML:
/*********************************************************************************
Set up XML data for two rows in...
June 13, 2012 at 6:42 pm
Have you seen the knowledge base document for your error message?
http://support.microsoft.com/kb/954950
Also, it sounds like you are attempting bi-directional replication? You mention above that you are trying to replicate from...
June 13, 2012 at 6:17 pm
Is it a single file composed of one XML node? Or is it a character-delimited file (i.e. one for BCP) that has a delimited column containing an XML-formatted string? Are...
June 12, 2012 at 9:19 pm
I have to second vinu512's comments. We shouldn't be debugging your sample scripts.
That said, I think this is what you are trying to achieve:
/*
Drop Table Mytable
Drop Table Mytable2
go
*/
/*******************************************************************
I...
June 12, 2012 at 1:01 am
Do you need to execute i14_get_ids for every row that is inserted into tblEvents?
Or maybe a better question is: exactly what are you trying to achieve?
For example, I mocked up...
June 10, 2012 at 9:48 pm
There is quite a bit of explanation involved so I included it all in the comments within the code. Hope this helps:
DECLARE @XMLdata XML
SET @XMLdata = '
<Root xmlns="http://Supervalu.JonesNewInvoiceFlatFileSchema">
<Header xmlns="">
<Body>201212403113INVOICE...
June 8, 2012 at 9:47 am
If I could make a couple suggestions for your posts in the future:
1. Try to keep the sample data small. You posted 725 lines of unreadable XML which was...
June 7, 2012 at 10:59 pm
I'm not entirely clear on some of the details. Is it an existing process which creates the daily database on the primary server? Or are you also asking how to...
June 5, 2012 at 11:56 pm
Okay, this makes sense now (and I feel a great deal less clever).
So GetDescendant returns a child node of the parent.
According to BOL:
parent.GetDescendant ( child1 , child2...
May 31, 2012 at 1:58 am
So it looks like you are trying to work through the technet example Converting a Table to a Hierarchical Structure (http://technet.microsoft.com/en-us/library/bb677237.aspx and have gotten stuck on the section where you...
May 30, 2012 at 11:48 pm
I agree with RBarryYoung. However, if there is some reason that you cannot use replication, I would recommend you research the following:
Paul Nielsen's open source Auto Audit: http://autoaudit.codeplex.com
Blog post...
May 28, 2012 at 11:11 pm
Viewing 15 posts - 1 through 15 (of 71 total)