Viewing 15 posts - 61 through 75 (of 2,756 total)
I could be mistaken, but I think it depends on the configuration. I am hoping this is your test system and not live and if so, I'd say try it...
July 19, 2024 at 4:27 pm
If you want a NICE tool for signing powershell scripts, I recommend this one:
https://www.idera.com/productssolutions/freetools/powershellplus/
Idera Powershell Plus. FREE tool which is always a huge plus, and it works really...
July 18, 2024 at 10:06 pm
To play devil's advocate, all of the applications I develop I design with a "quick drop" to SQL. What I mean by quick drop is that the application opens a...
July 18, 2024 at 9:29 pm
My opinion - setting the execution policy to bypass is a bad idea on a desktop and a horrible idea on a server. Sign your script instead.
The reason it is...
July 18, 2024 at 9:20 pm
I agree with Grant, I just wanted to add in another potential cause is drivers. For example, if you update your network drivers and you have your database storage on...
July 15, 2024 at 7:55 pm
Just was looking at that really long single line SQL and was trying to make it more pretty and there is some goofy stuff happening in your query. I see...
July 15, 2024 at 7:51 pm
My opinion - that REALLY depends on the company. For example, if you have a license for SQL Prompt, I would recommend grabbing that.
But as a bare minimum, for a...
July 13, 2024 at 7:23 pm
It is not likely you are going to find someone who will download a random zip file from someone to help with something like this. A better solution is to...
July 8, 2024 at 9:29 pm
True... Could you have the page break in as an expression that depends on how many rows are in the main report? What I mean is if the main report...
July 5, 2024 at 10:33 pm
Offhand I am not certain, but is it possible in the parent report (the one that will contain the sub-report) to put a page break before the sub-report?
July 5, 2024 at 8:00 pm
I don't have any issues with allowing traces to be run in the DEV environment. If I had to wait for a DBA to do that for me, it...
July 5, 2024 at 3:42 pm
My opinion - a developer shouldn't need to run a trace. That's a thing a DBA should be doing. If the developer needs a trace run, the DBA should initiate...
July 4, 2024 at 3:51 pm
Just to reply to both Jeff Moden and Seketon567 - I do agree that Fox was ONE of the places reporting on it, but I heard about it elsewhere. A...
July 4, 2024 at 3:27 pm
Weird question but did you upgrade from a previous version of SQL (2017 or older) to 2019? If so, your maintenance plan MAY be in a previous version format that...
July 3, 2024 at 7:57 pm
one thing you could try is to change @json table variable to a permanent table. That way you can read the response from the WEB API call.
Now, that...
July 3, 2024 at 7:46 pm
Viewing 15 posts - 61 through 75 (of 2,756 total)