A client with 86 databases struggled to find one in Object Explorer. A newer SSMS Enhancement lets you filter the Databases node. Here is how it works.
How to Attach a Database Without Log File in SQL Server
To attach a database without log file, run CREATE DATABASE with FOR ATTACH_REBUILD_LOG, or remove the missing log in the SSMS Attach dialog. This tutorial builds a demo database, detaches it, and rebuilds the log on attach. It also explains when the rebuild is impossible and what to check afterward.
SQL SERVER – SSMS Error During Restore: No Backupset Selected to be Restored
Restoring a SQL Server 2008 backup in SSMS 2012 gave ‘No backupset selected to be restored’. A reader’s question and what causes this restore error.
Install the WideWorldImporters Sample Database
To install the WideWorldImporters sample database, restore its backup file in SSMS and check the files and the row counts. This post explains the Full and Standard versions, the disk space you need, the permission trap, and three queries that prove the install worked.
Install SSMS: Setup and First Connection
To install SSMS, download the installer, run it, and connect to your server. This post explains why SSMS is separate from the SQL Server engine, how to fill in the first connection, what to do about the certificate error, and how to check the connection with one query.
SQL SERVER – Error: 14258 – Cannot perform this operation while SQLServerAgent is starting. Try again later
A client could not run any job and got Error 14258: Cannot perform this operation while SQLServerAgent is starting. Here is what caused it and how we fixed it.
SQL SERVER – Event 17058 – initerrlog: Could not Open Error Log File
SQL Server would not start and there was no ERRORLOG. Event 17058, initerrlog: Could not open error log file, came from missing permissions on the Log folder.