Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Sever FileTable Limitations

Posted on 2014-02-08
1
Medium Priority
?
572 Views
Last Modified: 2014-02-13
Is there any limit to the depth and number of shared filetable folders that can be set up?  I want to use the SQ Server 2012 Filetable option to retain all documentation and want to set up about about 24 folders each containing a subfolder.  Just want to make sure there is no limit.

Root Folder
   - Folder 1
      - Subfolder
   - Folder 2
   - Folder 3.....
0
Comment
Question by:hojohappy
1 Comment
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 2000 total points
ID: 39845181
Hi,
limits are 15 nested levels and you should consider Windows API limitations of a max path length of 260 characters.
Reference:
http://technet.microsoft.com/en-us/library/gg492087.aspx
HTH
Rainer
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question