Viewing 15 posts - 1,066 through 1,080 (of 1,583 total)
I've tried every version of the code pasted on the page and consistently get this error:
Msg 9436, Level 16, State 1, Line 1
XML parsing: line 5, character 15, end tag...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 15, 2012 at 12:00 pm
Thanks so much it's for the additional feedback in this, I will test out the CLR code to see if I'm gaining any advantage over the tally table method! ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 9, 2012 at 12:24 pm
While I am not 100% sure, I've always under the impression that procedures that had WITH RECOMPILE on them didn't retain the execution plans...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 8, 2012 at 1:04 pm
That's a very good question and in all honesty I don't know...I believe there's a uid (row guid/unique identifier) that is assigned to each row...but I'll have to check with...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 7, 2012 at 9:03 pm
MyDoggieJessie (6/7/2012)
CREATE FUNCTION [dbo].[fx_SplitExtents]
(
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 7, 2012 at 8:44 pm
Would soemthing like this work, or is it defeating the purpose of Jeff's work of art?
CREATE FUNCTION [dbo].[fx_SplitExtents]
(
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 7, 2012 at 2:26 pm
The number is the position, and the value can be 1-80 for some fields, 1-40 in some, and 1-20 in others
Ex:
dbo.SplitCMD([ts-fee-amt],80)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 7, 2012 at 2:15 pm
Check out this link: http://blogs.msdn.com/b/john_daskalakis/archive/2009/11/13/9921916.aspx
I've had this happened before (not with the JDBC drivers) and the cause could relate to your issue as well.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 1, 2012 at 11:40 am
Make sure the temp tables are dropped. when you first executed the script the temp tables were created then when you attempted to rerun it, it fails because that...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 1, 2012 at 11:35 am
jei33 (5/18/2012)
Question:
if you have detected that huge article as the conflicting one, wouldn't be enough just to drop that article from the publication, instead of deleting the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 31, 2012 at 2:02 pm
Please post the exact code you are using and I will take a look at it - thanks
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 31, 2012 at 11:00 am
Videos would be great, however, examples which are more practical would be even better. All too often I've found that the examples in most books hardly ever relate to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 4, 2012 at 7:38 am
If you set up transactional replication using the GUI, it does quirky things behind the scenes (like automatically set settings you really don't want). To ensure you don't take...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 26, 2012 at 6:24 am
I knew I should have completely finished my first cup of coffee for the morning before posting this 😀
Issue resolved (walking away with tail between my legs in shame...)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 24, 2012 at 8:15 am
Might sound lame, but check to see if there's some System DSN created (in Administrator Tools, ODBC)
Sounds like there might be a "prd" in that that's pointing to your "local"...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 19, 2012 at 11:05 pm
Viewing 15 posts - 1,066 through 1,080 (of 1,583 total)