• the_rs (9/24/2008)


    Kevin:

    Is Deepa's statement true that if somebody accesses/modifies the file bypassing SQL Server, it may render the file corrupt?

    venki

    First, re-read my post about direct file access. It is ONLY allowed under the control of SQL Server. So nobody can access the file outside of SQL's control. Changes are logged and can be rolled back before you commit the transaction, even after you close the file handle. If someone has legitimate access to that cell in the database, and is putting a new value in the FILESTREAM column, then you get whatever they put in, EXACTLY THE SAME as if they put that same value in a Varbinary(max) column. The main difference is that now after you pass the SQL security checks, you can get the data into the column much more efficiently using the file handle.

    Kevin


    Kevin Farlee
    SQL Server Storage Engine PM