1. Save the attached to a folder, say: /snippets/
2. Create a folder under snippets , say: /snippets/My Snippets/
3. So now you have a .snippet file and a folder in: /snippets/
4. Go to SSMS and hit: CTRL+K,CTRL+B (hold the CTRL key down and hit K, then B
5. Click: ‘Add…’
6. Find and select your “My Snippets” folder on your OS
7. Back at the Code Snippets Manager, Click: ‘Import…’
8. Navigate to your root /snippets/ folder and select the .snippet file that you downloaded from this email
9. Select to add this file to your “My Snippets” container (check the box on the right) and click: Finish
10. Now you are ready to execute the “Surround With” command you added…
11. Either run the command to start off a query, OR, highlight a table name to query.  Hit: CTRL+K,S (hit K then S while holding down CTRL)
12. Just use your arrow keys and the ENTER to find and select your new command within your “My Snippets” container so you don’t have to leave the keyboard
13. Below was the result of me highlighting the fully qualified table name and executing the snippet

 <?xml version="1.0" encoding="utf-8" ?>   

 <CodeSnippets  xmlns="https://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">   

 <_locDefinition xmlns="urn:locstudio">   

     <_locDefault _loc="locNone" />   

     <_locTag _loc="locData">Title</_locTag>   

     <_locTag _loc="locData">Description</_locTag>   

     <_locTag _loc="locData">Author</_locTag>   

     <_locTag _loc="locData">ToolTip</_locTag>   

    <_locTag _loc="locData">Default</_locTag>   

 </_locDefinition>   

 <CodeSnippet Format="1.0.0">   

 <Header>   

 <Title>SELECT_TOP_1000</Title>   

                         <Shortcut>t</Shortcut>   

 <Description>Snippet for SELECT TOP</Description>   

 <Author>Patrick Fitzgerald</Author>   

 <SnippetTypes>   

    <SnippetType>SurroundsWith</SnippetType>   

 </SnippetTypes>   

 </Header>   

 <Snippet>   

 <Declarations>   

                <Literal>   

                <ID>SELECTOP1000</ID> 

                <ToolTip>SELECT TOP 1000 From Selected Table</ToolTip> 

                <Default>SELECTOP1000</Default> 

                </Literal>   

 </Declarations>   

 <Code Language="SQL"><![CDATA[SELECT TOP 1000 * FROM $selected$$end$;]]>   

 </Code>   

 </Snippet>   

 </CodeSnippet>   

 </CodeSnippets>