using c# we create test data from an existing database using a linked server and the openrowset tsql command