Hi,
I try to update SP3a to our SQL2000, but it stopped at script
80sp3-tools.sql, after some of research I think is the msdb database
table 'RTblClassExtension' and stored procedure
'r_iRTblClassExtension' objects were no longer owned by 'dbo'
I am not MSDBA, so have no ideas on how to set those object to 'dbo'
can some one give me a step by step on how to fix this issue?
TIAHi,
use msdb
go
sp_changeobjectowner 'current_owner.RTblClassExtension',dbo
go
sp_changeobjectowner 'current_owner.r_iRTblClassExtension',dbo
Replace the current_owner with the current object owner.
Thanks
Hari
MCDBA
"MousePad" <mouse@.pad.com> wrote in message
news:i7hq50d5j240kj7f9mptprs877q194s68t@.
4ax.com...
> Hi,
> I try to update SP3a to our SQL2000, but it stopped at script
> 80sp3-tools.sql, after some of research I think is the msdb database
> table 'RTblClassExtension' and stored procedure
> 'r_iRTblClassExtension' objects were no longer owned by 'dbo'
> I am not MSDBA, so have no ideas on how to set those object to 'dbo'
> can some one give me a step by step on how to fix this issue?
> TIA
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment