Archive for March, 2012

Adding User Instance database to SQL Server Management Studio

March 4, 2012 Leave a comment

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;
Select owning_principal_name, instance_pipe_name
from sys.dm_os_child_instances;
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
Categories: ASP.NET