Thanks. That was the original plan (the loop) I was just looking for a quicker way

Thanks, this looks like more of what I wanted.

Thanks to everyone who responded. I'm going to look at the various options and decide from there.

I have a table with several million address records and I am trying to create a sample file. I want to get 10 records for every zipcode on the...

Thanks. We're a small shop so we have no real experts and I am always looking for help.

Yes

I'm sorry, I re-typed the command and left out the database name. I got the file names by looking at the properties of the database before I detatched it...

I don't have access to the log but I have the error message:

error 9003: The LSN (519:13819:1) passed to log scan in database 'Testjes' is invalid..

I used the following statement:

sp_attatch_db...

I appreciate the help. I've tried what you said but I keep getting an error message 9003 stating that the LSN in the log scan is incorrect. Any...

Thanks to 5409045121009 and Antares686. These examples were just what I needed