Viewing 15 posts - 16 through 30 (of 2,889 total)
You can script your PROD MyTable table as CREATE to a SQL window, change the table name to MyTable_Stage, and change all the data types to VARCHAR(nn) , then run...
May 8, 2023 at 6:57 pm
Go to DB Properties. What is the last log backup date ?
I just changed a FULL DB to SIMPLE and it still shows the last Log backup date after I ...
May 8, 2023 at 5:41 pm
When I have similar problems, I make a staging table with the same fields as production, but all defined as appropriate length VARCHAR to eliminate (or reduce) data mapping errors....
May 8, 2023 at 5:25 pm
Thanks for the comprehensive reply.
April 18, 2023 at 3:05 pm
It appears Datto also runs "DIFFs" during the day, but they also show as type 'D' in the SQL backupset table, not 'I' , and do not impact the native...
April 17, 2023 at 8:55 pm
"... ORDER BY 3 ..."
I recommend against this. Name the field.
If a new field gets added as 3rd field, you will get different results.
And, nobody knows what field '3' is,...
March 20, 2023 at 3:50 pm
Are these tables already being used ?
If so, Identify the "trouble areas" and look at how to fix them, rather than just build indexes you think might be needed.
March 20, 2023 at 3:46 pm
Sounds like he doesn't deserve the help.
March 2, 2023 at 5:50 pm
March 2, 2023 at 5:18 pm
Got the first post on a page again... and again, it's not showing up until another post (this one) is made.
I reported that bug in May 2022. I guess...
February 23, 2023 at 9:25 pm
Does it trigger when you start the service and terminate it using taskmanager?
Yes, those DO send the email.
Maybe I misunderstood the functionality, and "Run a Program " activates only...
February 23, 2023 at 6:15 pm
I've never made a dumb mistake like that.... well ... except for that time, and that other time, and then there was that other time also .....
February 23, 2023 at 2:53 pm
Here's my powershell script (with company information changed)
I'm "assuming" that since it works when I run the BAT file manually, which runs powershell, that it would use the same permissions...
February 23, 2023 at 2:08 pm
I don't see any benefit to the extra lines. Just takes up space and results in more scrolling.
[These] [brackets] [also] [add] [to] [clutter]. I use them sparingly.
SELECT
...
January 25, 2023 at 8:11 pm
Heh... I've been having issues with caffeine absorption lately. 😀
Too much ? Or not enough ?
December 8, 2022 at 4:52 pm
Viewing 15 posts - 16 through 30 (of 2,889 total)