January 30, 2014 at 4:28 am
Dear All,
Login ENABLE or DISABLE is made any change in sys.syslogins tables.
Please clarify.
January 30, 2014 at 5:02 am
syslogins is an old SQL 2000 compatibility view. Since you couldn't disable logins in SQL 2000, the view won't show the disabled property. Use sys.server_principals, which is the current view that displays logins, and you'll see a column called is_disabled.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 30, 2014 at 10:05 pm
Thank you Sir,
Please clarify what is difference between Permission to connect to database engine and Login in the Login Properties windows ?
February 2, 2014 at 8:45 am
Maybe you want to check BOL
http://technet.microsoft.com/en-us/library/ms180015%28v=sql.105%29.aspx
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply