I want to know the import/export tables from enterprise in SQL Server 2005.
I know that,we can import/export database but i want to know,
about tabels ?
This last message together with the title makes me wonder again about what you mean under import/export. Do you mean table level backup/restore (i.e. the "export" is a file with "bak" extension ?) When you say import/export a database, do you actually mean a backup? If so, you have two choices (that I'm aware of
) You can either use filegroups, and backup entire filegroups, or, you could continue backing up the whole database, but use third party tools to do table level backup restored. In either case, you will need to ensure database consistency manually.
Andras Belokosztolszki, MCPD, PhD