Hi! All. I have one database consist of 15,000 records , then I want to split it into 4 database. but theres a kicker. the records should be split as

record 1 in the database 1
record 2 in the database 2
record 3 in the database 3
record 4 in the database 4

record 5 in the database 1
record 6 in the database 2
record 7 in the database 3
record 8 in the database 4

record 9 in the database 1
record 10 in the database 2
record 11 in the database 3
record 12 in the database 4

until it will reach 15,000 records


is there a function that can split database in this procedure.

Appreciate all you help.

Thanks
Elmer

Happygv posted and sent me a file to handle similar tasks. Do a search in the SQL server " Split Database" and see if it can be helpful to you.