when I right click a table I can select select top 1000 rows and edit top 200 rows
I'd like to add an option select bottom 1000 rows
I am pretty sure that I've seen it somewhere online how to do this. But I can't remember where...
already found this: http://sqlserver-training.com/how-to-change-default-value-of-select-or-edit-top-rows-in-ssms-2008/- but it seems impossible to add a template query...
Have you tried SSMS Tools Pack? http://www.ssmstoolspack.com/ This should be able to do exactly what you need, and more. Specifically, look at the "Running custom scripts from object explorer" feature listed on the home page.