SQL Server 2005 Select Multiple views or Tables
Home > IT Answers > SQL Server > SQL Server 2005 Select Multiple views or Tab...
SapwizSAP
5 pts.
0
Q:
SQL Server 2005 Select Multiple views or Tables
SQL 2005, SQL Query Analyzer, SQL Server 2005, SQL Multiple Views, 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
ASKED: Mar 18 2009  0:07 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
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 Answered: Mar 18 2009  1:41 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0