Browse by Tags
All Tags »
FILESTREAM (
RSS)
Configuring a software feature is usually much harder than removing it. Most of the times, removing a feature could be just a matter of a mouse click or a simple command/statement. So what do you think about this question? Enabling FILESTREAM storage...
Excepts from a conversation between Sumit and Leena, that I overheard last week. Don’t know who they are?? Never mind, I will introduce them later! Leena : “Sumit, I am playing with the FILESTREAM access level and I am bit confused as I am getting a ...
I heard this question recently on one of the forums. The situation is as follows: Save an Excel 2003 document in a FILESTREAM column Read the data from the FILESTREAM column and try to open in Excel – It works as expected Save an Excel 2007 document in...
When a VARBINARY(MAX) column is marked with the FILESTREAM attribute, the limitation of 2GB is not applicable on the value any more. You can store values larger than 2GB in such a column. The maximum size is limited only by the size of the disk. A FILESTREAM...
This question was asked in the comments section of my FILESTREAM article at simple-talk.com . I thought it may be a better idea to write a detailed blog post explaining it along with some sample code, rather than writing a short answer in my return comments...
I had been blogging a bit about the FILESTREAM feature of SQL Server 2008 recently. I have just published a rather long article on FILESTREAM, at simple-talk.com. You can read the article here: http://www.simple-talk.com/sql/sql-training/an-introduction...
I see this error reported many times in the online forums. This usually happens if you try to create a FILESTREAM enabled table in a database that is not configured for FILESTREAM usage. To be able to store FILESTREAM data in a database, the database...
“Well, when accessing from TSQL, FILESTREAM enabled columns are not different from other regular columns and the code is not different from the regular code that you write”. This used to be my usual answer to people who ask me this question. I also had...
The Unattended installer can take two additional parameters (optional) to configure FILESTREAM as part of the installation process. /FILESTREAMLEVEL This parameter can be used to specify the FILESTREAM Access Level. This parameter can take one of the...
SERVERPROPERTY() function can be used to retrieve the Windows Share name configured for FILESTREAM access. Here is an example: SELECT SERVERPROPERTY ( 'FILESTREAMShareName' ) AS FileSreamShareName /* FileSreamShareName ------------------ -- KATMAIFS...
I am exploring the FILESTREAM data type these days for my next book. So expect a number of blog posts on FILESTREAM in the next few weeks. Yes, I am back to SQL Server blogging after a short break. I would like to start with clarifying a common misunderstanding...