Viewing 15 posts - 2,956 through 2,970 (of 9,725 total)
Peter2012 (1/13/2015)
Hi Brandie,Thank you for your response.
Those errors are coming from SQL logs, so there should a way to extract them using SQL query. This is what I'm looking for.
So...
January 15, 2015 at 5:01 am
I am positive that you are trying to squeeze too much data into the variable, but I cannot find anything on the internet that indicates how much data an object...
January 15, 2015 at 4:56 am
Luis Cazares (1/14/2015)
Brandie Tarvin (1/14/2015)
Koen Verbeeck (1/14/2015)
Luis Cazares (1/14/2015)
Congratulations Koen! When I grow up I want to be like you. :hehe:Action figures will soon be available! 😎
With or without superhero...
January 15, 2015 at 4:47 am
Koen Verbeeck (1/14/2015)
And you know, for some reason MS still likes to ask XML related...
January 15, 2015 at 4:44 am
I'm glad you found something you could work with.
Happy coding. @=)
January 15, 2015 at 4:37 am
Making the links clickable...
lmarkum (1/14/2015)
I did a little research and came across a link to a Microsoft Support article that discusses how this error gets triggered. That led...
January 15, 2015 at 4:26 am
Koen Verbeeck (1/14/2015)
Luis Cazares (1/14/2015)
Congratulations Koen! When I grow up I want to be like you. :hehe:Action figures will soon be available! 😎
With or without superhero capes?
January 14, 2015 at 12:01 pm
The dynamic SQL is going to be hard to get around unless you hard code all your USE DATABASE statements.
There are two ways of getting around the sp_MSforeachdb. The...
January 14, 2015 at 10:08 am
Koen Verbeeck (1/13/2015)
Jimmy123 (1/13/2015)
Fairly certain. Think I has been stung by this recently. I am now definitely thinking convert to csv.
I tested it and the numeric value is imported as...
January 14, 2015 at 6:04 am
Koen Verbeeck (1/13/2015)
FYI, I received the Author of the Year award at MSSQLTips.com!Thanks everyone for voting!
Congrats!
January 14, 2015 at 6:02 am
Excellent.
Apparently option 1 is the option of choice. My only worry was that if you were in production, it might stop stuff in the middle of processing.
Does that help?
January 13, 2015 at 9:05 am
IncidentalProgrammer (1/6/2015)
Grant Fritchey (1/6/2015)
January 13, 2015 at 9:01 am
Jason,
Is this production or a non-prod environment?
January 13, 2015 at 8:58 am
Quick technical question (don't hurt me!). Google Fu refuses to tell me the max size of an object variable in SSIS 2008. Anyone know this off the top of their...
January 13, 2015 at 8:22 am
Jeff Moden (1/13/2015)
Tony++ (1/13/2015)
To ask the silly and obvious: Are they both either compressed or uncompressed?Doing full as compressed & diffs as uncompressed could get you that closeness in size.
I...
January 13, 2015 at 8:18 am
Viewing 15 posts - 2,956 through 2,970 (of 9,725 total)