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.
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.
You can then right-click on the selected objects & script them to a single T-SQL query.
Be First to Comment