Execute the following Microsoft SQL Server T-SQL script to turn on the FILESTREAM facility on the current server instance. You can also use Object Explorer GUI to configure it. The FILESTREAM feature, new to SQL Server 2008, provides a way to store and access large ( > 2GB) binary values, either through SQL Server or by direct access to the Windows NTFS file system. It can be used for smaller varbinary(max) storage as well.
USE Master
Go
EXEC sp_configure 'filestream access level', 2
Go
RECONFIGURE
Go
Related articles:
No comments:
Post a Comment