Solved

task paramter

  • 15 January 2020
  • 3 replies
  • 64 views

Badge +1

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

 

icon

Best answer by Mark Jongeling 15 January 2020, 12:56

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

View original

3 replies

Userlevel 6
Badge +13

Hey 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

Badge +1

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

 

 

Userlevel 6
Badge +13

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

Reply