Senin, 07 Juni 2010

Watch your CREATE CERTIFICATE *_DATE clauses syntax order!

I just noticed that given the way SQL Server parser parses the CREATE CERTIFICATE statement, the order in which you specify START_DATE & EXPIRY_DATE clauses really matters.If you specify the EXPIRY_DATE clause first, whatever value you specify is set as the expiry date attached to the certificate, but if a START_DATE clause is encountered afterwards then the start date is set to whatever value

Tidak ada komentar:

Posting Komentar