Error: Value cannot be null. Parameter name: viewInfo (Microsoft.SqlServer.Management.SqlStudio.Explorer)
I came across this error on a test database server when I launched the SSMS. The version of SQL Server I was using was 2008 R2 SE. A dialog box with following message would prompt whenever I click on anything in the management studio.
Value cannot be null. Parameter name: viewInfo (Microsoft.SqlServer.Management.SqlStudio.Explorer)
The...
Wednesday, December 11, 2013
Friday, December 6, 2013
Oracle - ORA-01172/ORA-01151 [ Baby does not cry =)]
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01172: recovery of thread 1 stuck at block 7583 of file 2
ORA-01151: use media recovery to recover block, restore backup if needed
SQL> recover database;
Media recovery complete.
SQL> alter database open;
SQL> select * from dba_data_Files where file_id=2;
FILE_NAME
------------------------------------------------------------------------------------------------------------------------
...
