Viewing 15 posts - 421 through 435 (of 2,917 total)
Wanted to throw my hat into the ring on this - I have done both. In-place upgrades and migration upgrades. My biggest factor in deciding the method is "how many...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 20, 2023 at 3:25 pm
No can do in SQL Server according to the docs: https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16
Those state we have 1024 columns max in a table.
You'll need to break it up into multiple tables; probably want...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 19, 2023 at 4:04 pm
As a random thought, are you fully patched on both SSRS and SQL Server?
Also, when you uninstalled Standard, did you reboot after the uninstalls? And did you reboot after the...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 19, 2023 at 4:00 pm
I could be dumb, but this really sounds like a homework/assignment style question. That being said, if I asked something like this, my first question would be "what does the...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 19, 2023 at 2:11 pm
I suppose that is a good point Jeff. In this specific scenario where the OP is trying to write the file to the server itself, having the data flow from...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 18, 2023 at 8:01 pm
One nice thing is that with email notifications, things show up how you would expect. The other fun thing is it happens outside of the code block too:
those above...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 18, 2023 at 4:57 pm
Oh I agree with you here Jeff. When things are set up properly, xp_cmdshell can be secure, but I find that a lot of times, it is used and abused....
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 18, 2023 at 4:55 pm
@steve-2 Jones - replace the _ with a space and you'll see what's happening.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 18, 2023 at 4:45 pm
If there are no jobs (maintenance plans are still jobs) or scheduled tasks, then I'd say something must be happening on the Azure side of things that is backing it...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 18, 2023 at 2:46 pm
My opinion - don't. Firstly, SQLCMD mode is a client side thing (ie part of SSMS) not a server side thing (ie not part of SQL Server Engine) so SQLCMD...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 18, 2023 at 2:16 pm
My question would be do you need to use replication for this?
What I mean is could you modify the stored procedure that updates the primary to ALSO update the secondary...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 15, 2023 at 9:58 pm
If I understand correctly, could you do something like this:
SELECT [T1].* -- or could do [T2].*, not certain which table row you are trying to show, you...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 15, 2023 at 9:33 pm
Thanks for the links Frederico_fonseca - unfortunately it is not a docker thing. In my case it looks like it is a vulnerability scan and it is just driving me...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 14, 2023 at 5:04 pm
Thanks for the tip! I'll send a question out to the IT team as I would LOVE to have that fixed... although I am a bit concerned that changing it...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 14, 2023 at 4:15 pm
Another thing to point out - your data looks to be inconsistent:
A DB 130 9/1/2023
A DB 120 10/1/2023
why did "DB" shrink by 10 MB that day/month?
But in...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
December 13, 2023 at 2:52 pm
Viewing 15 posts - 421 through 435 (of 2,917 total)