does the view return encrypted data? we're unlikely to help. breaking encryption is a no-go subject here. talk to the code developer. or do you want to see the SQL behind the view? script the object in SSMS.
when a view is created with encryption it gets dissappeared from syscomments.so now what my question is how to see that view in syscomments. is it possible to decrypt it again or is there any other way.