Dynamic SQL & Digital Signature procedures with SQL 2005

Dynamic SQL (DSQL) is very powerful and sometimes it is quite dangerous too in terms of security, within SQL 2005 the new feature called digitally signing module within DSQL. Before that it is important to learn and understand any such feature in order to use it properly. So by using the digital signature as a mechanism to extend permissions affects any operation on the body of the signed module, including dynamic SQL executed in it. So for further information on these methods refer to the following articles:Module Signing
Understanding Execution Context
procedure signing demo
how to use counter signatures
ImprovingDataSecurity