I have two issues.
1) I have to copy view data from one Database to Another database ,In both this databases the same views are avilable ,when using the export import wizard it is showing the destinations views are unavilable and create destination radio button is marked.BEcaues
of this will this create a new destination table with the same name as view?
2) I have one table which is owned by one user (Other than dbo) and the destination DB we do not have this owner and the default owner it is showing as dbo how can i create this owner and asign this table to the new owner (with data)
Thanks in advance
View Complete Post