Management Studio (SSMS)

Manipulating Multiple Objects in SQL Server Management Studio

  • Article

Every now and then, I see someone doing repetitive tasks in SQL Server Management Studio such as dropping a stored procedure one by one when they need to remove ten or scripting out a single object at a time because they can't select multiple objects from the Object Explorer. I have even seen people create elaborate scripts to perform tasks that involved manipulating multiple database objects to avoid these mundane tasks. In this tip I will show you how this can be done simply by using SQL Server Management Studio.


5,770 reads


VMworld 2020 – Top 10 Database Sessions (Part 1)


Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 24 Sep 2020


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

VMworld 2020 SQL Server session preview


Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview...

Read the latest Blogs


Where do I start from ?

By Corobori

Following with a user complain about SQL timeout I bumped into one issue with...

Function Code

By sizal0234

Hi, I have a fn with below code I want to understand the highlighted...

Backup size

By caz100

Hi Is it possible to have a database size showing 75 gigs and then...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers