How do I set a password to be null
How do I set a password to be null?
Expert
As ASE 11 (I cannot remember when this was with the very first release of 11, but not fixed before), the password column within syslogins has been encrypted. Setting that column to NULL does not associate to that login having a NULL password. Still a NULL password needs the correct binary string to be within place.
In release 12 and above, set the minimum password length to be 0 by using sp_configure and offer that account a null password, and all should be well.
Before 12, it is not possible to set the minimum password length; therefore the direct approach is not possible. Thus, update the relevant record in syslogins setting the password column to be similar as that of an account along with a NULL password previously.
Explain Triggers and Rules?
Why do normalized tables need more complex SQL when SQL statements are employed in application programs?
Describe why stored procedures decreased network traffic.
Can we have a report with several data providers?
Write down the Target Types on the Server?
What are sequences, and what are the possible problems when employing them to make surrogate keys?
Name the methods and types of Collision Resolution Techniques used in each of the type?
Contrast a fat and a thin client?
Define the term filter?
Specify the types of dimensions?
18,76,764
1951618 Asked
3,689
Active Tutors
1425056
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!