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
Categories: ASP.NET
Comments (0)
Trackbacks (0)
Leave a comment
Trackback