Script multiple objects in SSMS

Aim: To script multiple database objects using the Object Explorer Details window in SQL Server Management Studio (SSMS).

It’s not possible to script multiple objects at the same time from the Object Explorer window in SSMS.

01_script_object_explorer

However, by opening the Object Explorer Details window from the View menu, you can navigate to the relevant folder for a database (e.g. Stored Procedures) & select multiple objects in that folder.

02_object_explorer_details

You can then right-click on the selected objects & script them to a single T-SQL query.

03_script_multiple_objects

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Kevin Kline

Career and Technical Advice for the IT Professional

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Powershellshocked

A blog about PowerShell and general Windows sysadmin stuff

Simon Learning SQL Server

I'm trying to become "better" at SQL Server and data - here's how I'm doing it!

%d bloggers like this: