Can snippets be stored to a on premise SharePoint document library?

• 
  Hi @Marzipan
  
  Thanks for your post. 
  
  Snippets are stored within SQL Prompt itself as a part of SSMS and so this isn't possible or needed. 
  
  You can always check the documentation pages and can search for specific terms in there if you need to find any further information. 
  
  https://documentation.red-gate.com/sp9
  
  I hope this helps. 
  
  Kind regards
  
  Richard Lynch. 

  RichardL April 16, 2018 15:45

  - 0 +
• 

  RichardL said:

  
  Snippets are stored within SQL Prompt itself as a part of SSMS and so this isn't possible or needed. 
  
  You can always check the documentation pages and can search for specific terms in there if you need to find any further information.
  

  As per your second point, the documentation does say that you change the location of snippets and/or settings, direct link:
  
  https://documentation.red-gate.com/sp9/managing-sql-prompt-behavior/changing-the-location-of-the-settings-and-snippet-folders
  
  In regards to *needed* - I agree it's not needed, however, it's a good feature that allows everyone in a team to connect to the same snippets/settings thus ensuring everyone is working the same way (if that's the way someones company works).
  
  Dave.

  WRBI April 17, 2018 11:31

  - 0 +
• 
  So assuming Windows 10 and SharePoint 2013; the answer is to create a folder in the SharePoint document library where you want to store the snippet's, mine is called "SSMS Snippets", go to the LIBRARY tab, under the "Connect & Export" section, select "open in Explorer" then copy the address to the SQL Prompt Snippet Manager, Snippet folder.  Example, is  "\\[SharePoint url]\DavWWWRoot\teamsites\ART\SQL Snippets\SSMS snippets"

  Marzipan August 08, 2018 14:50

  - 0 +
• 
  Yes, you can but it advised to use the SharePoint Online over SharePoint on-premise. You can use Microsoft SPMT to do so. Additionally, you can also perform SharePoint Migration to another account if you need to perform cloud migration.

  ricksharma January 31, 2025 07:52

  - 0 +

Add comment

Please sign in to leave a comment.