Connecting SQL Express Manager to User Instances
Use Master
GO
Select owning_principal_name, instance_pipe_name
FROM sys.dm_os_child_instances
GO
HOSTNAMEUserName \.pipe4104C6A7-5175-45tsqlquery
Connect to
np:\.pipe4104C6A7-5175-45tsqlquery
About this entry
You’re currently reading “ Connecting SQL Express Manager to User Instances ,” an entry on Chui's Counterpoint
- Published:
- 4.10.06 / 12pm
- Category:
- SQL Server
No comments
Jump to comment form | comments rss [?] | trackback uri [?]