SET QUOTED_IDENTIFIER  ON    SET ANSI_NULLS  ON 
GO

/****** Object:  View dbo.WebTechFiles    Script Date: 1/23/2000 1:11:06 PM ******/
if exists (select * from sysobjects
                where id = object_id(N'[dbo].[WebTechFiles]') and
                        OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[WebTechFiles]
GO

CREATE VIEW WebTechFiles
AS
select top 100 percent Path, Directory, cast([filename] as varchar(255)) AS [filename],
                        [Create], [Write]
from openquery
(
filesystem,
'select Path, Directory, FileName, Size, Create, Write, Access, ShortFilename, Attrib
 from scope
(
''deep traversal of
 "C:\Documents and Settings\Umachandar Jayachand\My Documents\SQL 6.x - 7.0 Scripts"'',
''deep traversal of
 "C:\Documents and Settings\Umachandar Jayachand\My Documents\SQL 7.0 Scripts"'',
''deep traversal of
 "C:\Documents and Settings\Umachandar Jayachand\My Documents\SQL 2000 Scripts"'',
''deep traversal of
 "C:\Documents and Settings\Umachandar Jayachand\My Documents\WSH VB Scripts"'',
''shallow traversal of
 "C:\Documents and Settings\Umachandar Jayachand\My Documents\CMD Scripts"'',
''shallow traversal of
 "C:\Documents and Settings\Umachandar Jayachand\My Documents\VFP Resources"''
)'
)
where charindex('~' + [FileName] + '~', '~exclude.txt~') = 0
order by 2, 3

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON 
GO

This page was last updated on May 01, 2006 04:28 PM.