SQLSTATE 01000 ALTER PARTITION SCHEME

• Franky Leeuwerck

  SSCrazy

  Points: 2036

  More actions

  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.

• Franky Leeuwerck

  SSCrazy

  Points: 2036

  More actions

  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.

• Franky Leeuwerck

  SSCrazy

  Points: 2036

  More actions

  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.