#SQL MANAGEMENT STUDIO 2008 R2 STORED PROCEDURE PROFILE DOWNLOAD#

Step 3: To clear the filter and list all objects again, right click on filtered category and select Filter > Remove Filter. Step 2: In the Filter Settings dialog box, specify ' Sales' in Value field, and click on OK to apply filter:Īfter applying this filer Object Explorer will only show stored procedures matching the specified filter criteria, only those which have word 'Sales' in their name in this case: You can automate the indexoptimze script to run for specific time. Sql agent is used to automate maintenance. Next time, You just will need to run the IndexOPtimize sp alone (not the entire script). Step 1: Right Click on Stored Procedures category in required database and select Filter > Filter Settings: Go to sql management studio adn run it in once, so Stored procedure will be created with name 'IndexOptimize'.

Many of you might create a New Stored Procedure using the New Menu Item as shown below: your needs.

#SQL MANAGEMENT STUDIO 2008 R2 STORED PROCEDURE PROFILE DOWNLOAD#

Table, Views, Stored Procedures etc.įor example, if we need to locate a stored procedure which has 'Sales' in name we can use Object Explorer filtering as below: Download Microsoft SQL Server 2008 R2 Management Studio Express for Windows computer for free. So here is another trick in SQL Server Management Studio. You can apply a filter in Object Explorer for common object categories. To resolve this you can Object Explorer provides filtering for objects. Object Explorer in SQL Server Management Studio lists all objects according to category and it may be hard to locate specific object. Expand Databases, expand the AdventureWorks2012 database, and then expand Programmability.

In Object Explorer, connect to an instance of Database Engine and then expand that instance. When you are working on a database with a large number of objects sometimes it becomes a challenge to locate objects. To create a procedure in Object Explorer.

Sql management studio 2008 r2 stored procedure profile