Viewing 15 posts - 241 through 255 (of 9,725 total)
I just took a glance at the trigger. The size of the thing is truly horrendous.
Not sure if it was truly built for single row processing because it'll probably take...
June 14, 2021 at 2:02 pm
Brief tangent into real SQL stuff...
Has anyone ever heard of table triggers not firing for every row if you do set-based updates to records?
Our vendor sent us code for an...
June 14, 2021 at 1:01 pm
I wasn't actually the one who pushed the SSIS packages to this particular server. I'm not sure if it was just imported straight from 2012 to 2019 or if it...
May 5, 2021 at 10:57 am
Despite the above reply, if anyone has ever seen this behavior before or has any ideas (aside from telling me to change how I run the package), please let me...
May 4, 2021 at 9:47 pm
We don't have catalogs set up and we've got such a tight deadline on the server upgrade that I don't have time to set them up right now. Catalogs are...
May 4, 2021 at 7:06 pm
event viewer - see this link for some info https://docs.microsoft.com/en-us/sql/integration-services/performance/events-logged-by-an-integration-services-package?view=sql-server-ver15
better to run packages on filesystem or catalog - easier to check errors and easier to change logging level
Thank...
May 4, 2021 at 6:58 pm
The report returns nothing. It's completely empty despite our QA team having run several of the jobs that call the packages. But again, we're not using SSIS Catalog and the...
May 4, 2021 at 6:43 pm
I am SOOOOOOO confused. Help appreciated here: https://www.sqlservercentral.com/forums/topic/ssis-package-succeeds-but-fails
May 4, 2021 at 5:42 pm
Ah, okay. You've asked a question that happens to fit my editorial and writing expertise. Yes, the apps work on laptops, but yes, you still need a Kindle.
The reason being...
April 16, 2021 at 6:45 pm
Silly question for you. Why do you need a Kindle device when you could install the Kindle or Nook app on any tablet of your choice?
April 16, 2021 at 4:17 pm
HA! Finally got someone in corporate who had a clue and pointed me to the way to get the SqlServer module loaded outside of powershell.
Do manual download from https://www.powershellgallery.com/packages/SqlServer/21.1.18246-preview. Save...
April 13, 2021 at 5:29 pm
It doesn't, actually, because the output does the date in named format. "Apr 06 01:18 " for example. It's a little frustrating.
I'll keep playing with the code and see if there's...
April 12, 2021 at 1:22 pm
The Invoke command looks like what I need after taking a few hours to look it over, but now the problem I'm running into is that I can't install the...
April 12, 2021 at 12:55 pm
Spam can be very tasty given the right circumstances. I especially like turkey spam, grilled.
@=)
March 8, 2021 at 10:14 am
BWAHAHAHAHAHAHA... or maybe that should be WAAAAAAAAAAAAAAAHHHHHHH.
I opened a ticket with Microsoft regarding this issue. After an entire week of back and forth (and the version of ProcMon they had...
March 4, 2021 at 6:04 pm
Viewing 15 posts - 241 through 255 (of 9,725 total)