Archive for October 26th, 2012
Snapshot and Synonyms
Posted by Simon Cho on 10/26/2012
Posted in Common | Tagged: Snapshot, Synonym | Leave a Comment »
Dedicated Administrator Connection
Posted by Simon Cho on 10/26/2012
http://msdn.microsoft.com/en-us/library/ms178068%28v=sql.105%29.aspx
To use in SSMS please follow up those steps.
1. Enable SQL Server Browser.
Many of case for Network-Related error message is due to this reason.
2. Please use “Database Engine Query“, File>New> Database Engine query
This is keyword.
Do not open using object explorer since DAC does NOT support multiple sessions.
3. Add “ADMIN:” in front of server name
ADMIN:localhost
Posted in Common | Tagged: ADMIN:, DAC, Dedicated Administrator Connection | Leave a Comment »
Simon's SQL 