Properties and other dialogs failing in SSMS

Posted: May 5, 2010 in DBA, SQL Error Messages, SSMS

Error Message in SSMS

TITLE: Microsoft SQL Server Management Studio


Cannot show requested dialog.


Cannot show requested dialog. (SqlMgmt)

There is no row at position 0. (System.Data)

Problem is to do with system table spt_values being deleted.

Run this script to repair – the location may be different on your server.
C:\Program Files\Microsoft SQL Server\MSSQL\MSSQL.1\install\u_tables.sql

  1. rocket357 says:

    According to the msdn site, the options for corrupted master are: reinstall, reinstall latest servicepack, rebuild master. I tried the last one, but it seems rebuildm.exe is 2000 only, so I tried the second one and it did not work. I was about to reinstall completely, but I managed to google my way to this post. Thanks! (I’m a PostgreSQL DBA by trade, but maintaining some SQL Server 2005 machines was added to my job description haha).

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s