[code lang=“sql“]use mydb
go
select s.object_id, s.name, s.schema_id, s.type, s.type_desc, object_definition(s.object_id)
from sys.all_objects s
where type IN (‚P‘, ‚V‘, ‚FN‘, ‚TR‘, ‚IF‘, ‚TF‘, ‚U‘)
and is_ms_shipped = 0
order by s.type, s.name
go[/code]
[code lang=“sql“]use mydb
go
sp_helprotect
go
sp_helprotect ‚dbo.myview‘
go
sp_help ‚dbo.myview‘
go
select object_definition(OBJECT_ID(‚dbo.myview‘))
go[/code]