Problems with importing stored procedure in SQL server

Hi all,

I am trying to import data from a existing database to a new database in SQL server. IAm able to export the tables along with the data. Iam not able to import the stored procedures and views. Can any body help me out of this problem

Thanks in advance
Pinky

Hi Pinky,

I guess you can use DTS import wizard and select "Copy objects and data between SQL Server Databases" option in "Specify Table copy or query" step of the wizard. This will allow you to select in the next step the views/stored procedures that you want to import.

Another way of manually doing this is: Select whichever views/SPs you want to import (in Enterprise manager), right click and select All Tasks --> Generate SQL Script from the menu. The exeute this sql script on the target database.

Thanks,

Vikram