Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 procedure

Author  Topic 

Arun.G
Yak Posting Veteran

81 Posts

Posted - 2010-06-18 : 01:39:07
I have create table scripts for tables in one database

now , i want to drop a database,

before that if i execute a single procedure, giving a database name means,

1) it should copy all the tables and values in xls or csv file in a location
2) copy the scripts of all tables(backup)
3) drop the tables and database

same like , if i execute a procedure means

1) it should create a database, tables
2) load the values in table from csv /xls files

pls help...

how can i achieve this?

   

- Advertisement -