Hi Erland,

Stored procedures behaves the same.

I just noticed that when I look at the proterties of these views (in SSMS) being connected as a sysadmin user, the views appears not to be encrypted (as I wrote earlier). But when I connect in SSMS with a more restrictive user these views appears to be encrypted.

So when I query the sys.sql_modules.definition column being a sysadmin, I see the content of the definition column but with a more restrictive user I can't.

It makes sense and it is related to security.

Case close.

Best regards.

Carl