Adding User Instance database to SQL Server Management Studio

Follow these steps to add user instance database to SQL Server Management studio

1. Run this query from query window in SQL Server Management studio
Use Master;
GO
Select owning_principal_name, instance_pipe_name
from sys.dm_os_child_instances;
GO
2. Copy the instance_pipe_name
3. Click File -> Connect Object Explorer
  paste it in the server name field
4. Click Connect

You can attach user instance databases to this connection

Advertisements