Start Updating file author attribute with vb

Updating file author attribute with vb

FILESTREAM uses NT System Cache for caching file data.

Filestream allows us to store and manage unstructured datain SQL Server more easily.

Initially, the accounts of FILESTREAM assumed prodigious powers of concentration and cognition, and we mortals all recoiled numbly.

FILESTREAM feature may be enabled with three different levels of access to the FILESTREAM data, namely: If you are installing SQL Server 2008 in ‘Unattended mode’, you can use /FILESTREAMLEVEL and /FILESTREAMSHARENAME configuration options to configure FILESTREAM features.

For more information about installing SQL Server 2008 in ‘Unattended mode’, see How to: Install SQL Server 2008 from the Command Prompt Enabling FILESTREAM feature on a SQL Server 2008 Instance, installed without FILESTREAM features, would require a little more work.

The FILESTREAM feature allows storing BLOB data (example: word documents, image files, music and videos etc) in the NT file system and ensures transactional consistency between the unstructured data stored in the NT file system and the structured data stored in the table.

Storing BLOB data in NT file system, allows SQL Server to take advantage of the NTFS I/O streaming capabilities and at the same time, maintain transactional consistency of the data.

Now you can ask questions directly to me on my new site ASPForums.

Net Question Answer site, specially started to allow visitors of this site ask their doubts and queries. Just click the Ask Now button and ask your question now.

This is an additional step that is required only if you configure FILESTREAM after the installation of SQL Server.

Open SQL Server Management Studio and open the properties of the SQL Server 2008 instance.

To enable FILESTREAM feature, go to ‘SQL Server configuration Manager’ and right click on instance of SQL Server Service and select ‘properties’.


 
Dzisiaj jest:
22-Apr-2020 10:51