Click here to Skip to main content
16,020,622 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
How do I copy one view with data to another database in SQL Server 2005?
Posted
Updated 16-Jun-10 2:42am
v3

1 solution

Er, views don't contain data; the tables do. Provided you have the table in the other database with the data in it then simply create a script for the view and run it into the other database.

Second thought: you don't mean a view, you actually mean the table, don't you? If that's the case then use the Import data task.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900