How to operate multiple objects in SSMS (F7)

While working on a service restoration, we had to resume data movement on 100+ random databases. Generating TSQL is the best option but UI will be very quick and reliable.

Biggest challenge with SSMS UI will be to perform the action for each DB one at a time. I learnt about Object Explorer Details (F7) from my college (Thanks John)!

Simple Demo to Script 4 different tables at the same time!

1. Connect to the Server in SQL Server Management Studio (SSMS)
2. Click F7 (You can also click on View tab + Object Explorer Details)
ObjectExplorerDetails1

3. Select Tables from Object Explorer tab. Hold Control and select required table.
4. Right click -> Script Table As -> Create To -> New Query Editor Window
ObjectExplorerDetails2.jpg

Create Table script is generated for all selected tables!

Advertisements
This entry was posted in SQL, SQL Server, SSMS, Uncategorized and tagged , , . Bookmark the permalink.

2 Responses to How to operate multiple objects in SSMS (F7)

  1. Pingback: catalog | Blog for reference – Vijred

  2. Pingback: Fastest way to fix MSSQL Database with Suspect mode | Blog for reference – Vijred

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s