question

cpruden avatar image
cpruden 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
ssmsstored procedurescode
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

for what purpose?
0 Likes 0 ·
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
0 Likes 0 ·
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....
0 Likes 0 ·

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
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
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.