locked
Can't Expand the Views in Management Studio RRS feed

  • Question

  • Hi there,

    I am getting the below error when i am trying to expand the views folder in sql server 2005 management studio. Please advice. I am SysAdmin on SQL and CRM Dynamics 4.0

    "Failed to Retrieve the data for this request. (Microsoft.SqlServer.SmoEnum)
    Additional Information:

    SQL Server detected a logical consistency-based I/O error; incorrect checksum(expected: 0xd417deb5;actual: 0x3236925).
    It occured during a read of page in database id 41 at offset xxxxxxxxxxxxxx in file 'M:\Data\Sqlfile.mdf'"

    Thanks!

    Wednesday, August 12, 2009 2:31 PM

Answers

  • I don't think it's a permission issue.  I think it's something related to your database server.  I would recommend open a support case with Microsoft support team.
    Darren Liu | 刘嘉鸿 | MS CRM MVP | English Blog: http://msdynamicscrm-e.blogspot.com | Chinese Blog: http://liudarren.spaces.live.com
    • Marked as answer by Jim Glass Jr Thursday, August 13, 2009 5:44 PM
    Wednesday, August 12, 2009 9:00 PM

All replies

  • I would check the SQL server and the database, it doesn't seem like a CRM issue. 

    dump question but I have to ask, can you check to see if you have hard drive space left on your server?
    Darren Liu | 刘嘉鸿 | MS CRM MVP | English Blog: http://msdynamicscrm-e.blogspot.com | Chinese Blog: http://liudarren.spaces.live.com
    Wednesday, August 12, 2009 3:19 PM
  • I dont see what more permissions i need. I am domain admin, administrator on the server, and on sql server , have sys admin role on crm.

    about space, each drive have more than 500 gb space left.

    Please advice!
    Wednesday, August 12, 2009 4:51 PM
  • I don't think it's a permission issue.  I think it's something related to your database server.  I would recommend open a support case with Microsoft support team.
    Darren Liu | 刘嘉鸿 | MS CRM MVP | English Blog: http://msdynamicscrm-e.blogspot.com | Chinese Blog: http://liudarren.spaces.live.com
    • Marked as answer by Jim Glass Jr Thursday, August 13, 2009 5:44 PM
    Wednesday, August 12, 2009 9:00 PM