Copy a view from one database to another database on the same server I want to copy a view from one database to another database, on the same server. Both databases are structured exactly the same, except for about 8 views added in one.
Basic method:


Right click on the view in SQL Server Management Studio
Save as script to new query window
Change context to target database
Execute script


This is basically correct, but this will not preserve permissions on the views. A better way is to:


Right-click the database
Choose Tasks -> Generate Scripts -> Choose Objects -> Select specific database objects
Choose your views -> next
Click the [Advanced] button and then [Script Object-Level Permissions] should be set to True (default is False)