SQL Server 2005 Select Multiple views or Tables

SapwizSAP
5 pts.
Tags:
SQL
SQL 2005
SQL Query
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
Asked: Last updated:
Related Questions

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: