Viewing 15 posts - 1,801 through 1,815 (of 2,917 total)
Ok I am completely stumped on this one. I was trying to re-create the object using different flavors of dynamic SQL and casting and converting hoping I could trick 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.
June 26, 2020 at 9:37 pm
To add to what Phil said, the error you got seems to indicate the problem:
Bulk load failed due to invalid column value in CSV data file Jobs.txt in row 477,...
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.
June 26, 2020 at 8:16 pm
Oh that is a challenging one then. I was just trying to figure out how to reproduce that.
As a thought, I am wondering if there might be some character before...
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.
June 26, 2020 at 8:09 pm
Just so I understand things right, you are asking if you can filter the rows from table A that are replicated based on specific criteria? if so, this is entirely...
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.
June 26, 2020 at 7:46 pm
https://docs.microsoft.com/en-us/ef/core/modeling/entity-properties
Reading through that it sounds to me like EF doesn't support excluding columns when reading the database side of things BUT quick googles indicate that you can exclude a column...
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.
June 26, 2020 at 5:07 pm
I expect that is possible, but it would be messy to do and error prone and I expect difficult to maintain.
When doing changes like this, my preference is to make...
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.
June 26, 2020 at 4:50 pm
My guess with this is not a problem with the stored procedure naming but more with your permissions.
I just executed the following against a SQL Server 2016 instance and 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.
June 26, 2020 at 4:39 pm
This is a double post. Did none of the answers in the previous thread help?
The query is identical...
Link:
https://www.sqlservercentral.com/forums/topic/need-help-with-sql-code
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.
June 26, 2020 at 3:42 pm
I think the first step to troubleshooting this is knowing what error you get. Is it that it doesn't like your username/password or is it a TCP/IP error or 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.
June 26, 2020 at 3:41 pm
I am guessing you mean a SQL Server service pack update, right?
If so, have you tried going to the folder it extracted the data to and looking for a "setup.exe"...
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.
June 26, 2020 at 3:37 pm
A test environment is good for this and for other things too.
If you want to deploy a report for an end user to test (for example), this works great! Or...
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.
June 25, 2020 at 9:55 pm
As to what is in the logs, that I am not sure. I don't know what specific error messages will pop up, but the log will tell you exactly 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.
June 25, 2020 at 9:03 pm
Doing a quick google on error ORA-00933 - it sounds like that shouldn't be thrown with a SELECT statement. Is there more to the query that you did not include...
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.
June 25, 2020 at 8:43 pm
If the app is changing data and is doing it in a transaction, it could be they forgot to put a COMMIT in there. Unlikely, but possible.
The other thing that...
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.
June 25, 2020 at 8:23 pm
From looking at it, it looks like the columnstore index is giving a bad estimate and that is causing it to use the clustered columnstore index as the estimates make...
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.
June 25, 2020 at 8:18 pm
Viewing 15 posts - 1,801 through 1,815 (of 2,917 total)