Friday, February 24, 2012

Copy/Paste behavior in SSMS

I realize that this seems odd, but I want to change the copy paste
behavior in SSMS.
Right now if you have no text selected in SSMS and do a control-c the
entire line is copied, but I want the copy to be null. Basicly I'm
automating some repetive functions and need to move only the selected
text to the clipboard. If no text is selected then want nothing.
Any ideas?
Thanks
William
wgbrown_nospam_@.gmail.com
How are you automating the tasks?
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
<wgbrown@.gmail.com> wrote in message
news:1164146398.788232.175850@.k70g2000cwa.googlegr oups.com...
>I realize that this seems odd, but I want to change the copy paste
> behavior in SSMS.
> Right now if you have no text selected in SSMS and do a control-c the
> entire line is copied, but I want the copy to be null. Basicly I'm
> automating some repetive functions and need to move only the selected
> text to the clipboard. If no text is selected then want nothing.
> Any ideas?
> Thanks
> William
> wgbrown_nospam_@.gmail.com
>
|||Using Autohotkey - www.autohotkey.com. Its a scripting language to
automate tasks. Right now I've had problems pulling selected text
using its tools - some editors don't get along with it so I've resorted
to using the clipboard but the SSMS behavior is different that other
tools.
Thanks
William
Paul A. Mestemaker II [MSFT] wrote:[vbcol=seagreen]
> How are you automating the tasks?
> Paul A. Mestemaker II
> Program Manager
> Microsoft SQL Server Manageability
> http://blogs.msdn.com/sqlrem/
> <wgbrown@.gmail.com> wrote in message
> news:1164146398.788232.175850@.k70g2000cwa.googlegr oups.com...
|||I'm not famliar with this utility at all. Can you give us an example of the
task you'd like to automate? Maybe we can find you a way to complete your
task using SQLCMD Mode in SSMS.
-Paul
<wgbrown@.gmail.com> wrote in message
news:1164179204.938292.85990@.k70g2000cwa.googlegro ups.com...
> Using Autohotkey - www.autohotkey.com. Its a scripting language to
> automate tasks. Right now I've had problems pulling selected text
> using its tools - some editors don't get along with it so I've resorted
> to using the clipboard but the SSMS behavior is different that other
> tools.
> Thanks
> William
>
> Paul A. Mestemaker II [MSFT] wrote:
>
|||Good Morning Paul.
There isn't one function but a bunch of little ones. Currently I'm
closing off certain characters like { [ ( " so I get {}, [], (), "" (I
work a lot in mdx). But I'd like to be able to reformat highlighted
text. Proper case words or such.
I was surprised about the copy behavior - I'd never noticed it.
Thanks
William
Paul A. Mestemaker II [MSFT] wrote:[vbcol=seagreen]
> I'm not famliar with this utility at all. Can you give us an example of the
> task you'd like to automate? Maybe we can find you a way to complete your
> task using SQLCMD Mode in SSMS.
> -Paul
> <wgbrown@.gmail.com> wrote in message
> news:1164179204.938292.85990@.k70g2000cwa.googlegro ups.com...
|||See if this helps with what you want?
http://www.red-gate.com/products/SQL_Refactor/index.htm
Andrew J. Kelly SQL MVP
<wgbrown@.gmail.com> wrote in message
news:1164215484.851461.150040@.h54g2000cwb.googlegr oups.com...
> Good Morning Paul.
> There isn't one function but a bunch of little ones. Currently I'm
> closing off certain characters like { [ ( " so I get {}, [], (), "" (I
> work a lot in mdx). But I'd like to be able to reformat highlighted
> text. Proper case words or such.
> I was surprised about the copy behavior - I'd never noticed it.
> Thanks
> William
>
> Paul A. Mestemaker II [MSFT] wrote:
>
|||I've looked at that and it looks really nice. As soon as I have time I
want to try it out. Much of my work is around MDX however, and the
tools are more limited. For good reason, for every person who does MDX
there must be 1000 (or more) sql programmers.
Thanks for the tip.
William
Andrew J. Kelly wrote:[vbcol=seagreen]
> See if this helps with what you want?
> http://www.red-gate.com/products/SQL_Refactor/index.htm
> --
> Andrew J. Kelly SQL MVP
> <wgbrown@.gmail.com> wrote in message
> news:1164215484.851461.150040@.h54g2000cwb.googlegr oups.com...

No comments:

Post a Comment