
These INSERTS can be executed to regenerate the data at some other location. This procedure is also useful to create a database setup, where in you can script your data along with your table definitions.
-- Script all records from the drugcard rule table
EXEC sp_generate_inserts
@table_name = 'rule_med_drugcard'
-- Script all active records from the drugcard rule table
EXEC sp_generate_inserts
@table_name = 'rule_med_drugcard',
@from = 'FROM dbo.rule_med_drugcard WHERE active = 1'
Download here
Instructions and more