Page Count of a File

19 Mar 2005 3:07 PM

GK

Dear SQL Gurus:

I have some PDF files on a fileserver. I have the metadata for these files
in a table, which says, which file resides where, etc (DocumentID,
DocumentPath). I also have one column which is for PDF Pages for the
documents. I need to somehow pick the documents from the fileserver and get
the correct page counts for the fileserver.
We wrote an Extended stored proc for getting the PDF Pages, but its not
reliable and sometimes crashes the server.
Any ideas on how to accomplish this would be really appreciated. As always,
thanx a ton for everything.

Ganesh

21 Mar 2005 1:48 AM

Wei Xiao [MSFT]

I would not use extended proc in this case.

I would write a stand-alone program that talks to the file server, getting
the details of PDF files using some PDF API (I am not sure which), and then
update the SQL Server tables using standard SQL client API.

--
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix

This posting is provided "AS IS" with no warranties, and confers no rights.

Show quote

"GK" <G*@discussions.microsoft.com> wrote in message
news:F53A37BA-3E86-4C8F-BFA4-53B60D3FB265@microsoft.com...
> Dear SQL Gurus:
>
> I have some PDF files on a fileserver. I have the metadata for these files
> in a table, which says, which file resides where, etc (DocumentID,
> DocumentPath). I also have one column which is for PDF Pages for the
> documents. I need to somehow pick the documents from the fileserver and
get
> the correct page counts for the fileserver.
> We wrote an Extended stored proc for getting the PDF Pages, but its not
> reliable and sometimes crashes the server.
> Any ideas on how to accomplish this would be really appreciated. As
always,
> thanx a ton for everything.
>
> Ganesh