asked
Way to create bookmarks right in Stored procedure through annotations or such
I know that you can save bookmarks in a .sql file but I am working in a team with a number of large stored procedures and I would like to be able to have bookmarks created automatically through annotations or some mark up? I am using SSMS 2012 and 2014
we have a number of large SProcs which we edit every now and then. Bookmarks make it very easy to jump to a specific location when using SSMS. As bookmarks are at a file level not a code level it would be nice to be able to define a bookmark and when you modify a SPRoc it could create the bookmarks on load --@Bookmark Name=BM1 ... --@Bookmark Name=BM2 ... --@Bookmark Name=BMn
Thanks. Yes I started thinking about code Annotations because bookmarks associated to files are more difficult especially when Multiple people are working. Annotations just seem way more versatile! I have been working in SSMS for years and worked more in IBMs RAD (java) so VS is new to me and I wasn't sure if this existed??? I use comments with Find but the bookmark window is so much easier....
The bookmarks and bookmark management are only done within SSMS. The only function I can find for managing it are the keyboard shortcuts. Also, you're going to notice issues with persistence of the bookmarks you have. Here's a [Connect item on it][1]. Also, keep an eye out for [the order][2] in which you can scroll through them. [1]:
https://connect.microsoft.com/SQLServer/feedback/details/155778/bookmarks-for-microsoft-sqlserver-management-studio-should-be-persistent-and-associated-with-a-sql-file [2]:
https://connect.microsoft.com/SQLServer/Feedback/Details/296602
15 People are following this question.
