Try it. That is the best way to know for sure. Inserting into a temp table (as long as your tempdb isn't full, which will cause other problems as well) will succeed and you can drop it afterwards.
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.