SCCM database error
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: [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?
October 6th, 2010 8:50pm
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 |
October 7th, 2010 1:26am
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.
October 13th, 2010 2:24pm