Hi everybody,

I have database in sqlserver 7. I want to transfer particular stored procs and tables(with data) to another database in same sqlserver.

I have a project having database1 with some stored procs and tables, now i want to transfer the stored procs and table(some tables with data) to a new database2 in the same sqlserver7 in the same machine, using vb6.0, under Win2000

help is appreciated
lokey

hi there...

I supposed that you can't just do the copy by yourself, but wouldn't be easier to just deploy an sql file and do the copy that way???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========