Australia photo & PC memo

Archives

You are currently viewing archive for 29 June 2009

06/29: MS SQL > LOGON Trigger and Dedicated Administrator Connection (DAC)

Category: MS tips
Posted by: hajime osako
Add comment
SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’. Journey to SQL Authority with Pinal Dave

C:\Users\Pinal>sqlcmd -S LocalHost -d master -A
1> DROP TRIGGER Tr_ServerLogon ON ALL SERVER
2> GO

Sidebar

Search
Google
Categories
All
Australia > NSW
Australia > NT
Australia > SA
Australia > TAS
Australia > VIC
Cat
CISCO
Linux tips
MS tips
N800
Oracle
Security
Study
Web dev
Z. etc
Z. links
Z. memo
Calender
<   June 2009   >
MTuWThFSaSu
1234567
891011121314
15161718192021
22232425262728
2930     
Navigation
Previous 日
Next 日
Today
Archives
Login
Links
nucleuscms.org
docs.nucleuscms.org
forum.nucleuscms.org
wiki.nucleuscms.org
skins.nucleuscms.org
plugins.nucleuscms.org
dev.nucleuscms.org
Powered by Nucleus CMS
 
Copyright | Nucleus CMS v3.41 | Valid XHTML 1.0 Strict | Valid CSS | Back to top