Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Unanswered: Server: Msg 1921

    I am trying to add a primary constraint to the table and I am getting the following error:

    Server: Msg 1921, Level 16, State 3, Line 1
    Invalid filegroup 'secondary' specified.

    This is my statement

    alter table table1
    add constraint pk_table1 primary key nonclustered
    (col1) with fillfactor = 90 on secondary

    Any suggestions. Thanks.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 11
    One of two things is going on. Either, you do not have a secondary filegroup (do you have a case sensitive collation?). Or, you need to put the word "secondary" ion brackets. Not sure which. I know "primary" is a reserved word, and must be put in brackets, but I am not sure about "secondary".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts