Hi all,
Can someone explane what the purpose of the “Task parameter tags” and how it works. This can be found by the tasks.
There is no documentation avaibele on this subject yet.
Regards
Ronald Gombert
Solved
task paramter
- Apprentice
Best answer by Mark Jongeling
Hi Ronald,
Obfuscate logic has to do with hiding the Execution plan. In some cases you do not want to show the user the logic in a Stored procedure. By adding this Tag (not sure what value needs to be given) it will cause the procedure to be created 'With encryption’. More on that here: https://blog.sqlauthority.com/2008/11/01/sql-server-stored-procedure-with-encryption-and-execution-plan/
Hope this answers your question!
Kind regards,
Mark Jongeling
This topic has been closed for comments
+23Hey Ronald,
Tags can be used for various reasons. They are available for a lot of entities. For example it is usable when writing Dynamic model procedures. There you could say that every entity with a certain tag will be affected by your code.
More on tags is here: https://docs.thinkwisesoftware.com/docs/kb/tags.html
Hope this helps you!
Kind regards,
Mark Jongeling
- Apprentice
Hi
The documentation explain the standaard tag but not the tag which toy can select by the task. See picture below. The tag OBFUSCATE_LOGIC suggest that you can place code. Please explain the tag (three in total) and an example how to use.
Kind regards
Ronald Gombert
+23Hi Ronald,
Obfuscate logic has to do with hiding the Execution plan. In some cases you do not want to show the user the logic in a Stored procedure. By adding this Tag (not sure what value needs to be given) it will cause the procedure to be created 'With encryption’. More on that here: https://blog.sqlauthority.com/2008/11/01/sql-server-stored-procedure-with-encryption-and-execution-plan/
Hope this answers your question!
Kind regards,
Mark Jongeling
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.