Where are SQL Server Templates stored in a Docker Container of SQL Server DB

• Weegee71

  SSChasing Mays

  Points: 607

  More actions

  June 9, 2022 at 2:11 pm

  #4046945

  Hi there

  I have created a Docker Container and able to restore and operate SQL Server Databases within this container.

  Now I am connected to this SQL Server Instance via SQL Server Managment Studio and I am able to create  folders

  and templates in Template Explorer

  However I am not able to locate where these new created folders are stored

  They do persist when i close down and restart SQL Server Management studio but I am able to locate their location

  For example

  C:\Users\{username}\AppData\Roaming\Microsoft\SQL Server Management Studio\14.0\Templates\Sql\{your personal folder}

  But where are SQL Server Management templates stored in a Docker Container?

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  June 10, 2022 at 3:10 pm

  #4047565

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• ratbak

  Default port

  Points: 1411

  More actions

  June 10, 2022 at 3:26 pm

  #4047568

  Which version of SSMS?

  You're running your local SSMS and not SSMS in Docker, right? If so, you should be looking at your local path, not in the docker container. Templates are an artifact of SSMS, not SQL Server.

  If not, since you're talking about SSMS, I assume you are referring to a Windows Docker container with SQL Server since SSMS is not available in Linux. If so, does the container actually have SSMS installed? (SSMS has not been a part of the SQL Server install since 2016)

• Weegee71

  SSChasing Mays

  Points: 607

  More actions

  June 10, 2022 at 3:29 pm

  #4047569

  its the latest version 18.1  of SSMS im running and this was installed on my local windows ...on my hard drive and not in docker

  Now I did look at the local path....in fact i created 2 test folders in my template explorer...now normally I able to locate the Template folder on Windows explorer by searching for these test folders but i couldnt find them.