The environment is SCCM 2007 SP1 (R2) on server 2003. During the processing of the "Delete aged discovery data" task, the following error happens (every time) on the SQL server: "Microsoft SQL Server reported SQL message 4405, severity 16: [42000][4405][Microsoft][ODBC SQL Server Driver][SQL Server]View or function 't1' is not updatable because the modification affects multiple base tables." Can anyone provide some insight about how to go about troubleshooting this?

I get a very similar message from time to time. I've seen it discussed in these forums a couple times and I've never seen a fix posted. If you find one please post it. John Marcum | http://myitforum.com/cs2/blogs/jmarcum |

Hello, Here is a similar issue that for your reference: sms_database_notification_monitor error http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/0b6398be-37da-48ff-a0c1-5efd9b57d85c/ Thanks,Yog Li -- Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.