You’ve got a new computer? And you want to copy your code snippets over?
Or you’ve got a new colleague and want to share your stuff?
Or you’ve got multiple machines an want to keep snippets in sync?
You’ll want to know about
C:\Users\YourLoginName\AppData\Local\Red Gate\SQL Prompt 9\Snippets
Go on, have a look. You’ll see an assortment of XML-format files, with the extension
.sqlpromptsnippet. Those are the files you’re looking for. Knock yourselves out.