I need data for all countries and their states and then their cities. I want to build a web form where in dropdown i give user option to select a...

Hi.

Thanx for reply i am just running this in batch file

bcp"exec [DBNAME].[dbo].[SProcName]" queryout \\Severname\Projects\temp.CSV -S ServerName -U sa -P -t, -C

but i am getting this error...

I accomplish this task of copy table from one db to another by using

1. script to create table structure into another database

2. insert into new data base and select from...

No i cant restore database.The exact requirement is that i need to copy only one table with data with same primary keys to another database using sqlserver 2005 express.