Forum Replies Created
Viewing 15 posts - 1,786 through 1,800 (of 2,917 total)
Reply To: upgrade SSIS catalog got an error
Yeah, I'm a bit curious as well.
The error about version mismatches makes me think that the SQL instance was patched, but that the ISDBUpgradeWizard was not. Are there outstanding SQL...
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.
Reply To: RunRate , Forecast using Recursive CTE or UNION ALL
My only question with this is a pretty easy one - should your calculation to calculate the Forecast/RR for future months be per-customer, per Cost_Centre, or only look at 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.
Reply To: upgrade SSIS catalog got an error
This may be a silly question but did you install the 2019 SSIS along with the 2019 SQL Instance?
Next, does the following path exist:
D:\Program Files\Microsoft SQL Server\150\DTS\Binn\ISDBUpgradeWizard,
Those would be 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.
Reply To: value separate to text and unit not working when value have comma separated mult
I just wanted to confirm an assumption I had prior to working on this - the TextUnit value will never change in a "Value", correct? Plus, is the "TextUnit" value...
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.
Reply To: Unable to remove FILESTREAM filegroup that is not in use
Do you use FILESTREAM at all? If not, it may be safe to just turn the option off at the instance level or configure it to be "blank" at 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.
Reply To: Cannot Remove an Invalid Object
What I would strongly encourage you to do is get a test instance set up so you can try out the different methods suggested. The main reason to get 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.
Reply To: Cannot Remove an Invalid Object
So was able to replicate the issue!
My steps were to first create the database, create the stored procedure named mmytest. Next, changed Page Verify to NONE, took...
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.
Reply To: Cannot Remove an Invalid Object
Had not thought about that road. Here is what that script produced:
CAST([name] AS VARBINARY(MAX)) = 0x23006D0079007400650073007400
CAST('#mytest' AS VARBINARY(MAX)) = 0x236D7974657374
Other than the extra zeros they match.
These are not...
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.
Viewing 15 posts - 1,786 through 1,800 (of 2,917 total)