Viewing 15 posts - 556 through 570 (of 2,917 total)
As a guess (no access to or history of your system) - I would say that in some old old version of SQL Server, single user mode on system databases...
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.
September 6, 2023 at 3:42 pm
Possibly a silly question, but is there a reason for this obscure backup strategy? I am just trying to figure out why you would want to have backups taken sporadically...
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.
September 6, 2023 at 3:20 pm
One thing I would be careful of is that using AKV means your SQL instance relies on a cloud service to decrypt its data. This is important for 2 big...
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.
September 5, 2023 at 9:58 pm
Looking at the docs, it sounds like there should be no reason that this shouldn't work as long as AKV supports one of the methods that SQL Server supports.
That being...
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.
September 5, 2023 at 4:44 pm
My advice would be to do more staged upgrade and migrate it over to an SSIS catalog. Like upgrade from 2005 to 2008 R2 to 2012 to 2014 to 2017...
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.
September 5, 2023 at 4:32 pm
I personally can't read the screenshot, but kudo's to you frederico_fonseca for reading that!
Just as a second opinion on this, I think that is normal behavior as well. If I...
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.
September 5, 2023 at 4:25 pm
Yeah, that looks like it'll not work how you expect because your line:
set @upd_tab = (SELECT name FROM sys.objects where name like '%job queue entry$%' and type_desc...
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.
September 5, 2023 at 4:13 pm
Reading the notes on the link you provided, it sounds like things changed with custom authentication in 2017 in that it no longer relies on the ASP.NET stuff and now...
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.
September 1, 2023 at 8:14 pm
There is no "straight answer" to it as it highly depends on your usage. If the system is currently running, look at the max memory value and look how often...
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.
September 1, 2023 at 7:23 pm
Another thing to add is that each SQL instance needs SOME RAM. If you have your max memory for those set too low, you can run into issues.
I do agree...
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.
September 1, 2023 at 3:22 pm
For uploading the data set , that depends on how you set things up. For uploading the data source, yeah that is required otherwise the report has no idea what...
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.
August 31, 2023 at 5:54 pm
If I remember right, jobs do not migrate over when you do that. BUT since the old system is still available, just script out the jobs and run that script...
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.
August 31, 2023 at 4:22 pm
Also, I could be mistaken, but I am fairly confident that SQL Express handles up to 10 GB Databases, not 1 GB... and quick google confirmed this: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16
So, for a...
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.
August 31, 2023 at 4:08 pm
That should be all that is required. If they have browser permissions to the folder and file, it should work from the report server side of things. Where you MAY...
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.
August 30, 2023 at 8:04 pm
If I had to guess, I'd say your Oracle database connector isn't passing that information back. I'd look for a different database connector or see if you can configure 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.
August 30, 2023 at 6:34 pm
Viewing 15 posts - 556 through 570 (of 2,917 total)