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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Import/Export

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-03-11 : 07:19:57
Amir writes "Dear Madam/Sir,
Hi

I have a question about Importing a DB in SQL/Server 2000. Why when we import a DB into another server all Views objects transformed into table.Then I lost all of my veiws.How can I solve this problem?

Thanks

Best Regards,
Amir"

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2003-03-11 : 08:45:34
To Import a Whole DB Using Import/Export wizard you can select 'copy all objects and data between databases'. Here all views will not be transformed into table.

___________________________________________________________________________
Success is not a destination that you ever reach. Success is the quality of your journey.
Go to Top of Page
   

- Advertisement -