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.
Open SSMS and connect to a SQL Server Instance.
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
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.
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.
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.
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.
the TSQL code to successfully attach the SQL Server Database to your SQL Server
Note from the below screenshot the database was successfully attached and it is available
for user connections.