Hi All, Can u pls explain me to how to store the word document into sqlserver? i.e user can able to download the word document from sqlserver and can edit and again able to upload the document into sqlserver. Thank is Advance. Jai
You would need to store it in the image/Varbinary datatype. Take a look at Books Online you'll see some examples. http://www.sql-server-performance.com/forum/post.asp?method=TopicQuote&TOPIC_ID=11766&FORUM_ID=14 Importing Word Documents into SQL Server http://www.sqlmag.com/Article/ArticleID/37903/sql_server_37903.html MohammedU. Moderator SQL-Server-Performance.com
Hi, It is not recomended to store documents directly in SQL Server, Refer suggested Thread. Here is a link of a wonder full article on "BLOB or NOT to BLOB" onhttp://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2006-45 Regards Hemantgiri S. Goswami MS SQL Server MVP ------------------------- "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com
Jey What is the database size and also the expected growth? Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.