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 the connected and unconnected transformation?
Core Competency: Helps the managers to think towards developing the core competencies with the help of cloud computing. Huge benefits can be reaped out of the cloud computing.
What occurs while rows are determined using a FETCH statement?
Reduction in Cost: Huge reduction in costs can be achieved due to cloud computing both in terms of capital expenditure and operational expenditure. Since the organization now need not build its own
Explain the user objects?
Illustrates the ways to tune Reporting Services?
Specify the use of data stage designer?
Identify those statements are true about a foreign key?
Define the efficient data structure used within the internal storage representation in RDBMS?
Specify the different Multidimensional analysis methods which are available in the Business Objects?
18,76,764
1941134 Asked
3,689
Active Tutors
1460508
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!