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.
Describe the difference between differential backups and SQL Server 2000 complete?
What is meant by the Cardinality?What is meant by the Cardinality?
Write down a short note on the term concurrency transparency?
Explain the terms SQL Server and adaptive server enterprise?
Explain, what are Dimensional table?
Explain the way to set the number of lines upon a page of output and the width.
Write down a short note on the term domain constraints?
Explain the Slice and Dice attribute in the Business Objects?
Explain the Stored Procedure transformation?
Explain what do you mean by the virtual warehouse?
18,76,764
1929487 Asked
3,689
Active Tutors
1439205
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!