Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Monday, October 9, 2017

CREATE LOGIN from Windows... leaves hasaccess=0 sometimes?

SQLServerCentral » Latest topics
CREATE LOGIN from Windows... leaves hasaccess=0 sometimes?
Hey folks- thanks in advance if you can help with this.

I run several SQL Server 2014 SP1  clusters.  When we deploy a new one, we copy the logins using sp_help_revlogin.   Windows accounts get created with a statement exactly like

No comments: