Script to populate a LARGE test database?
-
Years ago, I ran in to a script that created a very very large version of the pubs database for testing purposes. Unfortunately, google nor I can locate it anymore.
Does anyone know of a script that can accomplish such a task?
Thanks!
-
declare @x as int -- for counter
declare @y as int -- for number of insert statements
set @x = 0
set @y = 10
while @x <= @y
begin
--put insert statement here
set @x = @x + 1
end
Just put your insert statement in the middle.
------------------------------
The Users are always right - when I'm not wrong!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply