I have created a file with the Logical Name 'Connection' and file group from database properties window. Now I want to assign this file to 'connection' table. So I have done the following steps:-
- Edited the table.
- Right click on table -> open the properties window.
- I have assigned "Regular Data Space Specification" to my file 'Connection'.
- Also I have assigned "Text/Image File group" to my file 'Connection'.
- I have saved the table and closed the table.
But when I edit the table and open the properties window, "Regular Data Space Specification" is showing my file 'Connection' but "Text/Image File group" is showing default name PRIMARY and not 'Connection'.
Can any one help me what I have made mistake.