How do you import a view from one database to another? I tried using the DTS wizard but when I pick the view I want to import, it is imported as a table and not a view. And I don't see anything in Management studio then can help me. Does anyone have any suggestions.
hi,
try generating the DDL script for the desire view, and then run it against the desired database..
regards
sql
No comments:
Post a Comment