Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reddy_vam
Starting Member
43 Posts |
 Posted - 2008-11-05 : 23:05:42
|
| Hi Folks,The "Update Statistics Task" of Maintenance Plan is failing with a error "Cannot create or update statistics on view "View name" because both FULLSCAN and NORECOMPUTE options are required.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."I am running on SQL Server 2005, sp2 I tried all the forums, but couldn't find exact solution for this issue.Any help resolving this issue will be appriciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-05 : 23:21:06
|
| duplicate threadhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=113939 |
 |
|
|
|
|
|
Maintenance plan fails: Cannot create or update s