Sunday, February 12, 2012

2005 Directory Tree

I am look to maintain a directory tree table in SQL Server 2005. The table
will contain details of file and folder paths, titles, size and a few other
additional fields not related to the file system.
Before I begin, and start writing code to maintain the table is there
anything in 2005 which could do most of the work for me? For example, the
file system be watched for changes and update the table automatically, i.e.
files or folders added, changed or deleted.
I keep hearing about all the fantastic new features in 2005, I would be
really impressed if it means I don't need to do any work for this.
Any help would be greatly appreciated.
DavidHi
There are no new functions in SQL 2k5 that can do this. Unfortunately SQL
Server is not build for file handling. I guess thats the only functionality
that Microsoft has missed out from that :)
--
"Davie" wrote:

> I am look to maintain a directory tree table in SQL Server 2005. The tabl
e
> will contain details of file and folder paths, titles, size and a few othe
r
> additional fields not related to the file system.
> Before I begin, and start writing code to maintain the table is there
> anything in 2005 which could do most of the work for me? For example, the
> file system be watched for changes and update the table automatically, i.e
.
> files or folders added, changed or deleted.
> I keep hearing about all the fantastic new features in 2005, I would be
> really impressed if it means I don't need to do any work for this.
> Any help would be greatly appreciated.
> David
>
>|||I am sure I read a while ago, think it was prior to release, Notification
Services can have a file system watch event?
"Omnibuzz" <Omnibuzz@.discussions.microsoft.com> wrote in message
news:7EDC42CB-A6C5-4B25-960F-9065284E6C8E@.microsoft.com...
> Hi
> There are no new functions in SQL 2k5 that can do this. Unfortunately
> SQL
> Server is not build for file handling. I guess thats the only
> functionality
> that Microsoft has missed out from that :)
> --
>
>
> "Davie" wrote:
>|||I am not sure about that. Sorry about the wrong info if one exists.
--
"Davie" wrote:

> I am sure I read a while ago, think it was prior to release, Notification
> Services can have a file system watch event?
>
> "Omnibuzz" <Omnibuzz@.discussions.microsoft.com> wrote in message
> news:7EDC42CB-A6C5-4B25-960F-9065284E6C8E@.microsoft.com...
>
>

No comments:

Post a Comment