Varchar dummy SQL fields

Question

I need to create a test database for use by some external developers.

We created a copy and instead of manually filling it with garbage data, I want to scramble the text fields.

Are there any easy ways to do this?

Im using SQL Server 2005 Sp

Answer 1

It might help .

Edit: here's a thread on another forum that might also be useful.

Good luck

Answer 2

, , , "" , , (, Prod) (, Dev offsite)

SQL http://www.petefreitag.com/item/466.cfm

, , ? , FirstName Surname Row, , firstname surname?