Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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:-

  1. Edited the table.
  2. Right click on table -> open the properties window.
  3. I have assigned "Regular Data Space Specification" to my file 'Connection'.
  4. Also I have assigned "Text/Image File group" to my file 'Connection'.
  5. 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.

share|improve this question
    
Step #1: Stop using the table designer. Step #2: see step #1. –  Jon Seigel Jun 20 '13 at 13:32
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.