Post reply

SQLSTATE 01000 ALTER PARTITION SCHEME

  • December 11, 2008 at 5:39 am

    #203911

    Hi there,

    Does someone has an idea what the following error message could mean ?

    ALTER PARTITION FUNCTION myPartitionFunction MERGE RANGE (20081130)

    ALTER PARTITION SCHEME myPartitionScheme NEXT USED myFileGroup (SQLSTATE 01000) (Message 0)

    Thanks in advance,

    Franky

    Franky L.

  • December 12, 2008 at 3:21 am

    #911520

    An update.

    The SQLSTATE 01000 error does not occur anymore on the ALTER PARTITION SCHEME statements.

    But, it still occurs on ALTER INDEX REBUID statements :

    ALTER INDEX myIndex ON myTable REBUILD [SQLSTATE 01000] (Message 0)

    All these statements are executed in an T-SQL script step that is part of a scheduled SQL Server Agent job.

    Someone a clue ?

    Regards,

    Franky

    Franky L.

  • December 12, 2008 at 4:20 am

    #911543

    Solved !

    Apparently, the " SQLSTATE 01000 (Message 0) " is a generic error message from failing T-SQL scripts executed as a SQL Server Agent job step.

    Approach : run the script in SSMS, which leads to more verbose output and better relevant error messages.

    In this case, a '.' in the name of index, caused the error.

    Franky

    Franky L.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply