Viewing 15 posts - 1 through 15 (of 137 total)
Giving this another bump to see if there is any general information someone can provide.
May 20, 2022 at 1:35 pm
I'll delete the proxy and add it back to see if that fixes the issue. It's strange that it's intermittent though
March 25, 2022 at 3:23 pm
Adding MAXERRORS = 0 to the bulk insert statement causes it to fail which is what I need. Trying to get a meaningful error to display in the catch is...
March 22, 2022 at 6:10 pm
I've verified all of the appropriate ports are open on the servers so everything looks good there. It seems like the server that cannot make the connection is routing it...
February 17, 2022 at 1:44 pm
I realize the question is very broad and that is likely due to me not having experience loading transactional data. What I'm getting out of all of the responses is...
January 21, 2022 at 1:47 pm
That makes sense. What about something like a web form where a new user enters all of their information (name, age, city, state, zip, income, ethnicity, email, etc) for whatever...
January 20, 2022 at 6:15 pm
No luck with the results to file. Thanks for the help though
October 29, 2021 at 2:32 pm
To expand on the reason I'm not using other DDL scripting methods is because I'm looping through hundreds of tables and running tests on converting data types and changing data...
October 29, 2021 at 1:27 pm
Changing it to select provided all of the characters. Now I need to figure out an easy way to copy those results since it loops over hundreds of tables all...
October 27, 2021 at 6:39 pm
When you say use select instead of print are you saying to toggle results to text and then use select @SQL1 which in my case has a string of 11,698...
October 27, 2021 at 5:41 pm
Phil - that helps limit each printout to 4,000 characters but in my case the string is 11,698 so it breaks it into three separate lines. The script I'm creating...
October 27, 2021 at 3:39 pm
Phil - Yes, the SQL PRINT output. In particular printing out strings, or concatenating, strings longer than 8,000 characters.
October 27, 2021 at 2:26 pm
My bad. Apparently I did not submit my post last week thanking Ant-Green for his solution and assuring this is not for SSNs or any kind of PII data. There...
October 27, 2021 at 1:57 pm
I just had a chance to get back to this and I can tell you it made a huge difference. Thanks, Scott!
October 14, 2021 at 12:33 pm
Out of those three options, the trigger might be the only one I'm able to use. I'm not a fan of going that route but I'll look into seeing if...
October 5, 2021 at 7:21 pm
Viewing 15 posts - 1 through 15 (of 137 total)