# HG changeset patch
# User Alexandre Fayolle <alexandre.fayolle@logilab.fr>
# Date 1285669337 -7200
# Node ID 74575fb32a4dbea94a34ebdb5e61a6dcccb25226
# Parent  14ec625b3f5561abd7661228b4c6faedb17920a3
[book] updated FAQ 'How to reset the password for user joe' with SQL Server syntax

diff -r 14ec625b3f55 -r 74575fb32a4d doc/book/en/annexes/faq.rst
--- a/doc/book/en/annexes/faq.rst	Tue Sep 28 08:36:24 2010 +0200
+++ b/doc/book/en/annexes/faq.rst	Tue Sep 28 12:22:17 2010 +0200
@@ -402,6 +402,12 @@
     mydb=> update cw_cwuser set cw_upassword='qHO8282QN5Utg' where cw_login='joe';
     UPDATE 1
 
+if you're running over SQL Server, you need to use the CONVERT
+function to convert the string to varbinary(255). The SQL query is
+therefore::
+
+    update cw_cwuser set cw_upassword=CONVERT(varbinary(255), 'qHO8282QN5Utg') where cw_login='joe';
+
 You can prefer use a migration script similar to this shell invocation instead::
 
     $ cubicweb-ctl shell <instance>