There are lots of ways of generating random strings in SQL Server. But instead of spending much time on finding solution to random password generation, here is an easy way to do that. SELECT SUBSTRING(convert(varchar(50),NEWID()),0,8) as password This generates 8 … Continue reading Randomly generate password in SQL Server 2008