locked
how to display all view names below the views section in a database RRS feed

  • Question

  • Hi All,

    I am using SQL Server 2008(SP2).

    I need to display all the view names below the Views Section in a database.

    Only System Views is present. but the database contains a good number of views in it. when I click on the views i am getting an error as,

    A severe error occurred on the current command. The results, if any, should be discarded.

    The database is read only. Please help on this issue.


    Thanks in advance, Akhila Vasishta


    • Edited by Akhila Vasishta Thursday, September 5, 2013 6:39 AM
    • Changed type Kalman Toth Thursday, September 5, 2013 7:23 AM
    • Moved by Kalman Toth Thursday, September 5, 2013 7:23 AM Not db design
    Thursday, September 5, 2013 6:36 AM

Answers

All replies

  • Sounds like you have a crash. For more info see these links:

    A severe error occurred on the current command...

    and 

    A severe error occurred on the current command...


    The most important motivation for the research work that resulted in the relational model was the objective of providing a sharp and clear boundary between the logical and physical aspects of database management. - E. F. Codd


    My blog

    • Proposed as answer by Saeid Hasani Friday, September 6, 2013 2:33 PM
    Thursday, September 5, 2013 6:46 AM
  • Can you see a list of views if you use the T-SQL and not Management Studio?  Eg.

    use <database>
    
    select *
    from sys.views

    If so then your database isn't correupt, but possibly there's something wrong with your installation of SSMS.

    Can you try from another machine using its SSMS?

    Thursday, September 5, 2013 6:53 AM
  • Should i need to set any permissions to the user to view those views? kindly let me know.

    Thanks in advance, Akhila Vasishta

    Thursday, September 5, 2013 6:55 AM
  • Yes.  If you have no read permissions on that database then you will not be able to see the objects.
    Thursday, September 5, 2013 6:57 AM
  • Hi Kevin,

    From the query itself i came to know that a good number of views are present in the database.

    The user has only read permissions to the Database.


    Thanks in advance, Akhila Vasishta

    Thursday, September 5, 2013 7:00 AM
  • If you can, I would try from another installation of SSMS and also try with different user accounts if possible...  therefore you would be able to see if it's SSMS which isn't working properly or if it's user access.  But if the query itself worked then chances are that your database is fine and it's just SSMS/permissions.

    However, I would run dbcc checkdb on it just to be on the safe side.

    Thursday, September 5, 2013 7:19 AM
  • Hi,

    DBCC Checkdb was also done.. Until now the issue has not been resolved.

    Please provide any more suggestions.


    Thanks in advance, Akhila Vasishta

    Friday, September 6, 2013 3:54 AM
  • I think its a permission issue.

    Can you try giving db_datareader role membership for the login?

    Login properties->USer Mapping->Select the database->Select db_datareader.


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Friday, September 6, 2013 5:42 AM
  • Hi,

    DBCC Checkdb was also done.. Until now the issue has not been resolved.

    Please provide any more suggestions.


    Thanks in advance, Akhila Vasishta

    Hi,

    You have not yet clarified if you have tried other installations of SSMS to see if it's a corrupt installation.  Or if you have tried using different user accounts in order to verify permissions.

    We cannot help if you do not test all offered solutions.

    Thanks,

    Kevin

    • Proposed as answer by Kevin Urquhart Friday, September 6, 2013 2:08 PM
    Friday, September 6, 2013 7:52 AM
  • This error is coming from SSMS, not the SQL Server database engine.

    Please install the latest service pack on your local machine and see if the problem still occurs.

    See: http://support.microsoft.com/kb/321185

    • Proposed as answer by Kevin Urquhart Friday, September 6, 2013 2:08 PM
    • Marked as answer by Kalman Toth Sunday, September 15, 2013 5:41 PM
    Friday, September 6, 2013 2:02 PM