SQL Server Developer >> Stange error message when migrating jobs to another server
Hi All,=20
After migrating the entire database using attach and=20
detach method from one SQL 2000 server to another one with=20
better prerequisites.
The jobs were transferred as well as everything else,=20
however they don=B4t succed anymore and generates a strange=20
error message diplayed below:
"[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column=20
specified is outside the range of the specified query=20
result=20
set. =20
(null)
Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]"
Does anybody know how this issue may be resolved. I would=20
be grateful for all the help I can get.
Do these jobs perfom as maint plan ?
Do you execute UPDATE STATISTICS and got this error?
Hi All,
After migrating the entire database using attach and
detach method from one SQL 2000 server to another one with
better prerequisites.
The jobs were transferred as well as everything else,
however they don´t succed anymore and generates a strange
error message diplayed below:
"[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column
specified is outside the range of the specified query
result
set.
(null)
Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]"
Does anybody know how this issue may be resolved. I would
be grateful for all the help I can get.