sp_helptext and definition of view being NULL

Question

When I try to EXEC sp_helptext 'dbo.VW_myname' I get the following:

There is no text for object 'dbo.VW_myname'.

And I get a NULL when i look at the definition of the view:

select definition
from sys.objects     o
join sys.sql_modules m on m.object_id = o.object_id
where o.object_id = object_id( 'dbo.VW_myname')
  and o.type      = 'V'

My question is two-fold: How come, I can't see the text behind the creation of that view and how can I find out how it is executed?

Answer 1

This happens when you don't have the VIEW DEFINITION permission.

Ask your DBA to grant you this permission.