Hello,
I am using VB6 and SQL Server 2000. Is there any method for coping database objects(Table (without data), procedure,views,etc) from one database to another by running a script from VB.
Thanks in advance
Kiran
Aum Namah Shivaya
Printable View
Hello,
I am using VB6 and SQL Server 2000. Is there any method for coping database objects(Table (without data), procedure,views,etc) from one database to another by running a script from VB.
Thanks in advance
Kiran
Aum Namah Shivaya
for SQL server it must be something like this. It must create a new table.
insert into db2.dbo.table2 select * from db1.dbo.table1
Iouri Boutchkine
[email protected]