Few days ago, one of my friend was facing an issue while creating Maintenance Plan in SQL Server 2005. When he was trying to create a Maintenance Plan, he was getting a message which says "Invalid column name 'from_msx'" and "Invalid column name 'has_targets'"
When we were trying to find out what might have caused this issues, we came to know that SP3 was recently applied to this instance.
This kind of errors usually pop up when the upgrades might have not completed properly.
Also in every service pack or hot fixes there will be a lot of changes like addition of tables and columns will be included for supporting the bug fixes or enhancements and if these are not applied properly to the database then you will get many similar errors.
To fix this particular issue, you have to execute the script "sysdbupg.sql" which will be present in the installation location <Drive>:\Program Files\Microsoft SQL Server\<InstanceID>\MSSQL\Install
Example: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install
Once this has been executed successfully, you will now be able to work with Maintenance Plans.
When we were trying to find out what might have caused this issues, we came to know that SP3 was recently applied to this instance.
This kind of errors usually pop up when the upgrades might have not completed properly.
Also in every service pack or hot fixes there will be a lot of changes like addition of tables and columns will be included for supporting the bug fixes or enhancements and if these are not applied properly to the database then you will get many similar errors.
To fix this particular issue, you have to execute the script "sysdbupg.sql" which will be present in the installation location <Drive>:\Program Files\Microsoft SQL Server\<InstanceID>\MSSQL\Install
Example: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install
Once this has been executed successfully, you will now be able to work with Maintenance Plans.
1 comment:
Đặt vé tại phòng vé Aivivu, tham khảo
giá vé máy bay đi Mỹ khứ hồi
đăng ký từ mỹ về việt nam
các chuyến bay sang nhật có bị cấm không
chuyến bay từ đức về hà nội hôm nay
từ canada về việt nam quá cảnh ở đâu
vé máy bay từ hàn quốc về việt nam
danh sách khách sạn cách ly ở tphcm
vé máy bay cho chuyên gia nước ngoài
Post a Comment