Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2011-01-03 : 15:37:14
|
| Happy New Year to Forum Friends,When I have scheduled the Maintenance plan on Reindex on the instance databases I am getting this as error.Executed as user: DHSV0\SQLProdAdmin. ...0) DBCC DBREINDEX('[dbo].[SITEID]') [SQLSTATE 01000] (Message 0) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) UPDATE STATISTICS [dbo].[SITEID] [SQLSTATE 01000] (Message 0) DBCC DBREINDEX('[dbo].[SERCURE]') [SQLSTATE 01000] (Message 0) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) UPDATE STATISTICS [dbo].[SERCURE] [SQLSTATE 01000] (Message 0) DBCC DBREINDEX('[dbo].[CHART5]') [SQLSTATE 01000] (Message 0) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) UPDATE STATISTICS [dbo].[CHART5] [SQLSTATE 01000] (Message 0) DBCC DBREINDEX('[dbo].[UPDATECOUNTS]') [SQLSTATE 01000] (Message 0) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) UPD... The step failed.On the otherhand if I execute Manually there won't be errors. can anyone suggest me where it went wrong.Thanks All. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-01-03 : 15:49:30
|
| There's nothing in what you posted that gives any error details. Configure the job so that it writes output to a file so that you can get the complete output of the job, then check that.--Gail ShawSQL Server MVP |
 |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-01-10 : 18:56:51
|
| This is the outputfile - when I ran for all the databases Job 'Reindex-Databases' : Step 8, 'Reindex-Whitecourse' : Began Executing 2011-01-10 13:32:16START TIME: Jan 10 2011 1:32PM [SQLSTATE 01000]DBCC DBREINDEX('[dbo].[GCHRTINS]') [SQLSTATE 01000]DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]UPDATE STATISTICS [dbo].[GCHRTINS] [SQLSTATE 01000]DBCC DBREINDEX('[dbo].[CDC_CD]') [SQLSTATE 01000]DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]UPDATE STATISTICS [dbo].[CDC_CD] [SQLSTATE 01000]DBCC DBREINDEX('[dbo].[CDC_MASTER]') [SQLSTATE 01000]DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]UPDATE STATISTICS [dbo].[CDC_MASTER] [SQLSTATE 01000]DBCC DBREINDEX('[dbo].[FILEINFO]') [SQLSTATE 01000]DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]UPDATE STATISTICS [dbo].[FILEINFO] [SQLSTATE 01000]DBCC DBREINDEX('[dbo].[GOLDLOG]') [SQLSTATE 01000]DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]UPDATE STATISTICS [dbo].[GOLDLOG] [SQLSTATE 01000]DBCC DBREINDEX('[dbo].[NHSCHD]') [SQLSTATE 01000]DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]UPDATE STATISTICS [dbo].[NHSCHD] [SQLSTATE 01000]DBCC DBREINDEX('[dbo].[WAITINGLIST]') [SQLSTATE 01000]DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]UPDATE STATISTICS [dbo].[WAITINGLIST] [SQLSTATE 01000]DBCC DBREINDEX('[dbo].[NOCALL]') [SQLSTATE 01000]DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]UPDATE STATISTICS [dbo].[NOCALL] [SQLSTATE 01000]EXEC sp_recompile '[dbo].[V_Reindex_Database]' [SQLSTATE 01000]Object '[dbo].[V_Reindex_Database]' was successfully marked for recompilation. [SQLSTATE 01000]Msg 2801, Sev 16, State 1, Line 89 : The definition of object 'V_Reindex_Database' has changed since it was compiled. [SQLSTATE 42000]However, Maintenance Plan Error has as above.Please let me know what went wrong.Thanks All. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-01-11 : 03:34:02
|
| "The definition of object 'V_Reindex_Database' has changed since it was compiled"Maybe V_Reindex_Database is a VIEW and contains SELECT * or somesuch, in which case it needs re-creating (or perhaps just recompiling if that is possible?) |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-01-11 : 19:58:44
|
| V_Reindex_Database is Stored procedure which I have successfully used in the previous times, I have recompiled this Stored procedure before it is re-attached for Maintenance Plan driven Agent job.Any further explanation many thanks |
|
|
|
|
|
|
|
|
Maintenance plan on REINDEX