none
an error message when I am practising to create partition scheme in exam book 70-432 sql2008 RRS feed

  • Question

  • hello,

    in the practice of the book of exam telling me to change context to the partitiontest database then execute  the onder statement to create a partition scheme mapped to the partition function.

    I tried first the USE DATABASE command to change the context to the partitiontest

    USE

    DATABASE partitiontest

    GO

    CREATE

    PARTITION SCHEME partscheme

    AS

    PARTITION

    partfunc

    TO

    (

    [FG1],[FG2],[FG3],[FG4],[FG5],[FG6],[FG7],[FG8],[FG9],[FG10],[FG11],[FG12],[FG13]

    )

    GO.

    and I get this error bellow

    Incorrect syntax near the keyword 'DATABASE'.

    Msg 208, Level 16, State 58, Line 1

    Invalid object name 'FG1'Msg 156, Level 15, State 1, Line 1. 

    after I tried the alter database command to change the context to the partitiontest

    .ALTER DATABASE partitiontest

    CREATE PARTITION SCHEME partscheme AS

    PARTITION

    partfunc TO

    (

     

    [FG1],[FG2],[FG3],[FG4],[FG5],[FG6],[FG7],[FG8],[FG9],[FG10],[FG11],[FG12],[FG13]

    )

    GO

    and I get this error message

    Msg 156, Level 15, State 1, Line 3

    Incorrect syntax near the keyword 'CREATE'.

    I don't know what I am doing wrong ,but I know that I am doing something wrong,can somebody give me some  advise.

    thanks

    johan

     


    h.david
    Monday, August 22, 2011 11:39 AM

Answers

All replies