SQL Server 2005 Select Multiple views or Tables

5 pts.
Tags:
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

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following