The “sa” user is the default user created during the Microsoft SQL Server installation. You must always disable or rename the “sa” user before handing the system to the operation team.
Sql Server Check Locks
So, how do you check if the “sa” user is renamed or disable.
How to Turn On or Off Spelling Autocorrect and Highlight Misspelled Words in Windows 10 Windows 10 includes a spell checking feature for when you type words anywhere in Windows 10. When autocorrect misspelled words is turned on, it will autocorrect your typed words on the fly if matched with the correct spelling of the word in the dictionary. To disable a CHECK constraint, use the NOCHECK argument within an ALTER TABLE statement. Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 35 Pluralsight courses and has written over 5200 articles on the database technology on his blog at a Along with 17+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.
Execute the following command line,
From the above screenshot, if the name is showing other than “sa”, it means the “sa” user has been renamed. In this example, it has been renamed to “opersys”. The “is_disabled” value 1 means that the user is in disabled state, means you cannot use this user to login.
Check Sql Server Version
Alternatively, use below command (no disabled status will be shown)