March 28, 2012 at 12:58 pm
My user needs to keep pdfs as legal documents. What is the best way to do that using ss2k8? Store paths in the table? or there is a way to "digitize" pdfs (sorry if that sounds naive)?
Thanks
March 28, 2012 at 1:10 pm
If you need to store them in the database you can use the varbinary(max) datatype. Another option is to use FILESTREAM. http://msdn.microsoft.com/en-us/library/bb933993%28v=sql.105%29.aspx
Hope that helps.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 28, 2012 at 1:41 pm
Ha! and ... when selected will the pdfs have the same design? (I will read what you suggested)
March 28, 2012 at 1:46 pm
valeryk2000 (3/28/2012)
Ha! and ... when selected will the pdfs have the same design? (I will read what you suggested)
LOL yes in fact they will. The option of course is always there to just have a pointer to the local file system too.
The varbinary datatype is a little tricky to work with until you figure it out. From the programming side is a byte array. I have used both types of storage for pdfs (and a pile of other document types) and the file on output is exactly the same as going in.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 28, 2012 at 1:47 pm
Sean, this article deals with R2 and mentions that "FILESTREAM RsFx driver is certified for Windows Server 2008 R2" - mine is just plain ss2k8 - does it matter?
March 28, 2012 at 1:48 pm
valeryk2000 (3/28/2012)
Sean, this article deals with R2 and mentions that "FILESTREAM RsFx driver is certified for Windows Server 2008 R2" - mine is just plain ss2k8 - does it matter?
Hit the other versions dropdown at the top. It should have 2008 but honestly I don't think anything changed with regards to FILESTREAM.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 28, 2012 at 1:52 pm
Look, the hard copy of pdf contains signature. If so, we probably should scan the signed copy to pdf first?
March 28, 2012 at 2:30 pm
Yeah whatever it is you need to store. I would guess the signed version would be the best option.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply