• This should get you started..

    declare @strSQL varchar(max)

    declare @viewName varchar(255)

    declare listViews cursor for

    select name from sys.views

    open listViews

    fetch next from listViews into @viewName

    while @@fetch_status = 0

    begin

    set @strSQL = 'select top 1 * from ' + @viewName

    exec (@strSQL)

    fetch next from listViews into @viewName

    end

    close listViews

    deallocate listViews