Overview of Template Explorer Feature in SQL Server Management Studio

This article will give you an Overview of Template
Explorer Feature in SQL Server Management Studio which was initially introduced
in SQL Server 2005. SSMS has a variety of inbuilt templates
which contains SQL Scripts that can help you create objects within SQL Server Database.

Let’s work through an example of using the Template Explorer feature in SSMS to Attach a database.

1.
Open SSMS and connect to a SQL Server Instance.

2.
Click the View
> Template Explorer option from the drop down
menu as shown in the below screenshot to open Template Explorer on the right side
of SSMS.

3.
In Template
Explorer expand SQL Server Templates > Database
and double click Attach Database to open the TSQL Script in a new query
window to attach database in SQL Server.

 

4.
Once the TSQL
Code to attach the database is open in SSMS, you can go ahead and make the required
changes to the TSQL code directly or you can click Query >
Specify Values for Template Parameters… to pass values to the template
as shown in the screenshot below.

5.
In the Specify
Values for Template Parameters
dialog box enter the values for database
name
and database primary file path as shown in the below screenshot
and click OK to replace the values within the TSQL script template.

6.
In the below
screenshot you could see that the values were replaced with the values provided in
the Specify Values for Template Parameters dialog box.

7.
Finally, execute
the TSQL code to successfully attach the SQL Server Database to your SQL Server
Instance.

8.
Note from the below screenshot the database was successfully attached and it is available
for user connections.




Array

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |