sql server dts: You could

1. Put this one table into a DB of it's own and use BACKUP/RESTORE
2. Export the data to text file and script the definition of the table.
Your friend then uses the script to create the table then imports the text
file.


--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community

hi
i would like to give one of my tables to my friend .
so that he can have the exact table at his home. with the data and all.
how do i do that.?
i thought about using dts. but how?

...using dts i can successfuly transfer tables from one db to another.


thanx
Zarish