can somebody tell me how to move tables from Dev to Prod Environment. thanks in advance

by the way i am in SQL server 2000

Why don't you use a dts package ?

how bout migrating store procs.

is there any way to do it without recreating it in Prod environment

If you want to recreate everything, why don't you take a DB back up and then restore in prod.

no i dont want to recreate it, i have do it without recreating it and when u do dts, it will load data too. i dont want that either. just table structure and some store procs.

thanks milliondollars

Create the scripts of tables and stored procedures if you want to just create table and stored procedures. It is very simple stuff.

thanks micky mocuse.

Xbox, i would do what Micky Mike suggested. It is prestty straight Forward.

Hey Xbox and Micky Mouse, are you guys SQL Server DBA? I am curious as i am also a SQL Server DBA(just started)...i think you guys might be able to help me out when i run into issues.

Please let me know.
Thanks

sure fewatal

Yes I do lot of database stuff in SQL 2000 and 2005. Thats good idea we can exchange our knowledge for our best.

Hi Xbox and Micky, Thank you for your response . i sent you email. Please check that and then send me response back with your email so that i can write u sometimes and share the stuff. I am kind a new in SQL server so i have hope that you guys wil help me ....i am a baby in SQL server but i love to work ..it is great

I look forward to hearing from you

Thanks a bunch!
Fewatal