Question :
There is an SP posted in the below link stating that it will insert dummy data in the entire DB. But the SP works only for a single table. Can anyone please share the one where we can insert dummy data throughout the db?
Answer :
I needed to do this for a staging environment to test performance before release. What i ended up doing was using sql data generator by redgate.
Way easier than a custom solution.