Home > IT Answers > SQL Server > SQL Server 2005 Select Multiple views or Tables
SapwizSAP
5 pts.
 SQL Server 2005 Select Multiple views or Tables
SQL 2005, SQL Multiple Views, SQL Query Analyzer, SQL Server 2005, SQL tables
in SQL 2000 it was easy to cntl-right-click and select multiple views, stored procedures or tables and generate one script which could be changed (using SQL Analyzer) to create new objects (search and replace text) with different names. This was a big time saver but I don't know how to do that in SQL 2005. It seems like the easy things in SQL 2000 are now harder to do in SQL 2005

Software/Hardware used:
ASKED: March 18, 2009  12:07 AM
UPDATED: March 18, 2009  1:41 PM
RELATED QUESTIONS
Answer Wiki:
Select tables from the tree view. Then in the Object Explorer Details window on the right (View > Object Explorer Details if it sin't there) you can control select the objects you want to script out. Then right click and you should be able to script the objects out. You can do pretty much everything in SSMS just as easily, just some things have been moved and have to be found again.
Last Wiki Answer Submitted:  March 18, 2009  1:41 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _