[RESOLVED] SQL 2005 Backup Table

[RobDog888]

Is there a SP or scripted task that I can use to backup a single tables contents to a file? Then I also need to script the table with all foreign dependancies and all custom data types too.

I have a 6+ GB database that I need to download from a clients servers and restore on mine for testing and development of a new project for them.

I could backup the entire database but it may take too long and put too much of a resource drain on their servers as users are online almost 24/7.

Thanks