Thanks for the question. Hoever, I got it wrong because I used this source:

http://msdn.microsoft.com/en-us/library/cc837966(SQL.100).aspx

which says:

"It is not possible to specify the salt value in SQL Server."

Can someone please expain why this is wrong? Or why I have interpreted it incorrectly. Thanks!