Viewing 15 posts - 1,081 through 1,095 (of 2,917 total)
Then that is weird. I've never come across that behavior before.
Any chance that the UPDATE is missing updating something that is causing the DELETE to fail?
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, 2021 at 5:58 pm
My first thought here is that it is rolling back when the cursor ends. Do you have ANY "ROLLBACK" statements inside your loop or after the loop but before 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.
June 25, 2021 at 5:24 pm
I think it depends on your requirements. I don't have any Azure instances to monitor, but I like SQL Monitor from RedGate. The price is right and the tool works...
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, 2021 at 5:20 pm
Scott - that is a good point. Time of day isn't the best use case for limiting stored procedure execution. A better use case would be for something like modifying...
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, 2021 at 5:11 pm
Looking at your log there, it says that the edition of SQL Server that installed the service does not support SQL Server Agent.
I would double check your installation media to...
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 24, 2021 at 6:07 pm
Some people really like the debug feature. My thoughts on it are that it was a pain to get set up and it seemed to be very inconsistent on 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.
June 24, 2021 at 5:42 pm
The error messages related to the SQL Agent sound like something is broken in MSDB. If this is a NEW 2019 install, I would do an uninstall and reinstall 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 24, 2021 at 4:09 pm
My opinion - I would refrain from any "execute all" or "read all" permissions. They are risky. I would operate on a least privilege model and create roles to access...
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 24, 2021 at 2:57 pm
I think that that is best practice anyway. My understanding is that on a server, you want as little overhead as possible which means not installing additional tools like SSMS. ...
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 24, 2021 at 2:34 pm
So it sounds like you want to adjust it to return the string minus the last character.
I would use a combination of LEFT and LEN (not 100% sure on 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.
June 23, 2021 at 6:53 pm
running the script from C:\ though is different than running it from c:\temp or any other folder. If "file.bat" is using relative paths instead of absolute paths, it may be...
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 23, 2021 at 6:48 pm
Depending on how you are doing the move from work table to reporting table, that could be the problem. Is it a wipe and reload? Is it a merge? 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.
June 23, 2021 at 6:03 pm
I generally don't install SSMS on the server. To me it feels like extra overhead for little benefit. I have SSMS installed on my workstation and I connect to 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.
June 23, 2021 at 3:09 pm
As a random guess (I can't see the code in your bat file), it is either using relative paths OR is using network shared drives.
Since SQL says it ran successfully,...
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 23, 2021 at 2:48 pm
As a thought, are you using NOLOCK?
As a second thought, are you doing any transforms on the data in the Data Flow task that MAY be changing the data?
Another thought,...
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 23, 2021 at 2:36 pm
Viewing 15 posts - 1,081 through 1,095 (of 2,917 total)