Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 SSMS Add-in

Author  Topic 

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-20 : 13:53:26
hey guys and gals!

if anyone has time and will i'd like you to try a
little SSMS Add-in i wrote:
http://weblogs.sqlteam.com/mladenp/archive/2007/09/20/SSMS-Tools-Pack---an-add-in-for-SQL-Management-Studio.aspx

works on SSMS 2005 and SSMS Express. NOT on SSMS 2008.

thoughts, opinions, etc... are welcomed

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-09-20 : 14:40:58
When I installed this, I saw all the options twice, including SSMS Tools Pack twice in the context menu

Thanks
Karunakaran
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-20 : 14:42:43
yes i'm aware of this. just restart ssms.
i haven't figured out yet why this happens to some people and not to others.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-20 : 16:14:54
I was just about to post that problem. The first set is blank after you hover but the second set isn't.

Haven't used the tool yet though.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-20 : 16:23:18
well the query execution history saved my behind a few times...

you know when you know you worked on a script a few days ago but you can't remember what exactly you did, etc...

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-25 : 15:47:38
One thing that I do not like about the tool is that it has repositioned items in my SQL Editor toolbar. I'd rather that any add-ins get put on the very right side of the toolbar than in the middle where I am expecting certain things to be.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-25 : 15:51:27
Thanx for letting me know!

i've since created a completly new toolbar for it's items which behaves the same as the normal toolbar.
i think that's better.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-25 : 16:44:15
Does it work for Katmai yet?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-25 : 16:46:40
nope.

i'm not plannig on adding support for 2008 until it comes out.
there's no support for extensibility in CTP as far as i know... i am looking into it though.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-10-08 : 16:35:16
quote:
Originally posted by spirit1

Thanx for letting me know!

i've since created a completly new toolbar for it's items which behaves the same as the normal toolbar.
i think that's better.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com



I just installed the build from your site and it's still putting your buttons in the middle of the Query Editor's toolbar. Did you prop the new build to your site?

also it's non-standard to create your own main menu item "SSMS Tools" - usually stuff like this would be under the Tools menu.

The execution history is very cool!



elsasoft.org
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-08 : 16:41:13
Agreed about the SSMS Tools menu item that it should be under the standard Tools menu.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-09 : 04:48:17
i haven't updated the build yet... haven't really had time yet.
i'll probably update it when i put out another version.
currently i'm working on function to search through exec plans and results in grid mode and creating insert statements...
i was wondering about insert statements since there are many tools for this, bit i prefer it all in one place.
since intellisense comes in Katmai I scraped that one.
new version will be out probably somewhere end of october or start of november.

hmm... interesting about the menu... most people i talked to prefer it on the main menu for easier access.
i'll probably add an option to put it in the place you prefer.

thanx for the feedback!

yeah... query exec history saved me a bunch of times. it's one the main things i was missing in ssms.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-10-09 : 09:48:14
What if you write 5 more addins? would they all have their own top level menu? top level menu starts to get very crowded then.




elsasoft.org
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-09 : 09:50:47
if i do i'll just put them in the pack

well i have redgate's refactor and prompt and mine installed which gives 3+ in the top menu. no crowding at all.

well since some people like it there i'll add an option to put it where you like. but it'll still start with the top level.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page
   

- Advertisement -