Viewing 15 posts - 886 through 900 (of 2,917 total)
Jeff - My GUESS is that it was an implicit conversion due to the division by int. I expect that Length is a CHAR or VARCHAR datatype, but holds FLOAT...
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.
October 21, 2021 at 10:05 pm
To me it sounds like you have an Azure SQL instance, not an Azure SQL Managed Instance.
Did a quick google and found this document from Microsoft:
https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison
If you scroll down 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.
October 21, 2021 at 9:37 pm
The reason it is not implicit is that there is no hard rule saying the default instance must run on port 1433, and most people change it off of 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.
October 21, 2021 at 9:25 pm
I second the "nonwork_days" table, but I would make sure to design the reason code table well.
You would want to make sure that the reason code table has a reason...
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.
October 21, 2021 at 4:21 pm
Could you post the DDL for the tables? Mostly, I am wondering what the datatype on "Length" is. If it is not a numeric data type (numeric, decimal, float, int,...
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.
October 21, 2021 at 2:01 pm
I am not 100% certain on the Access syntax for this, but I see a few potential solutions.
My recommended solution would be to do this as a stored procedure rather...
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.
October 20, 2021 at 5:34 pm
There are other solutions for sure, but they include risk. For example, you can take the database offline and modify it in a hex editor to correct the bad data.
If...
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.
October 20, 2021 at 2:22 pm
A lot of my advice still applies. I would try connecting by the FQDN name of the server as well as the port.
You ruled out DNS because you can RDP,...
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.
October 20, 2021 at 2:19 pm
Can your client machine see the servers? Could be firewall issues (that would be one of my first guesses) or network related. I would try connecting by the full name...
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.
October 19, 2021 at 3:46 pm
To add to what Johan said, I'd also check to make sure your database owner is a valid, enabled user. I've had service broker fail to send messages because my...
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.
October 18, 2021 at 9:58 pm
Did a quick google and came up with this link:
Which suggests turning up the remote execution timeout period at the SQL server side OR hardware/network issues. Since the query runs...
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.
October 18, 2021 at 9:17 pm
I am pretty sure that the problem is with that buffer pool size as the error indicated. The error is saying that the connection was closed by the remote host. ...
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.
October 15, 2021 at 8:11 pm
I believe the reason it is skipped is because the next restore step MAY include the steps that the undo phase would have undone. If you use NORECOVERY, SQL is...
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.
October 13, 2021 at 2:38 pm
The master key password is used to decrypt the master key. If you change the password AND you are decrypting it by password (as opposed to decrypting by the service...
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.
October 13, 2021 at 2:01 pm
looking at it, to me it appears that it is slow because you are looking at a LOT of data to review and then update a single row. Mind 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.
October 12, 2021 at 9:31 pm
Viewing 15 posts - 886 through 900 (of 2,917 total)