Cannot drop or modify partition descriptor database, Sybase
Posted on 2009-02-20
I wanted to know why this error is coming. We have a daily process which updates the data from one database to another. I don't see any any process which use the database table at the time when error occured. It happens intermittently as our process runs daily. The error is coming up on the line where we are creating the index.
Cannot drop or modify partition descriptor database 'databasename' (10), object 'name' (1040006736), index 'name' (0), partition 'name_1040006736' (1040006736) as it is in use. Please retry your command later. Total reference count '4'. Task reference count '2'.
<<< FAILED CREATING INDEX dbo.name.index >>>