Management Studio (SSMS)

External Article

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.

2010-01-11

5,770 reads

Blogs

Daily Coping 29 Jun 2022

By

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

Daily Coping 28 Jun 2022

By

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

Creating a Database Audit Specification can create new users & schemas in the background

By

I love database audits. They are simple, easy to use, effective, not overly resource...

Read the latest Blogs

Forums

How to set up Replication Alerts in SQL MI

By DanielP

Hello, Since Operators are not supported in SQL MI, how do you set up...

Attempting to run PS / DBA tools script as a SQL Agent job

By Summer90

If I run my PS script with PS as an ADMIN interactively it runs...

Data factory question

By hayunscha

Upon my adventures of Azure data factory and all the wonders it can do...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers