How to save in Sql Server or Filesystem?

[HardTarget]

Hi My friends,

I need to Know what should i do to save pdf file it's size about 300 kb.

Should i save it as BLOB in sql or as Fileserver?

ps. 9999 file mazximum per year .

Please i need your help as i want to start design my program asap.

Thanks

[ck9663]

Save it on a folder accessible by the SQL Server and save the folder and file name to your table instead.

Happy Coding!!!

~~ CK

[HardTarget]

Thanks ck9663 for your fast respond.

but how can i access this file through network using UNC Credential ?
like shared folder but no one can access it unless using user name & password passing them through my code .

[Rabbit]

Just set up the permissions on the folder and give them a link. No need to reauthenticate when you can just let the existing permissions take care of it.