Home All Groups Group Topic Archive Search About

SQL 2005 Management Studio - no more user-defined keyboard shortcu

Author
1 Mar 2007 9:03 PM
CadeBryant
Unlike SQL 2000 Query Analyzer, in SQL 2005 Management Studio, it appears
that you cannot configure a keyboard shortcut command to trigger a
user-defined stored procedure.

For example, if I set Ctrl+3 to trigger a system proc such as sp_helptext,
it works.  But if I set it to trigger a user proc, it doesn't work.  I have a
proc called sp_tablesample, which returns the top 100 rows of the table name
that's passed in as a parameter.  This is very helpful for when I need to get
a quick view of the type of data that's in a particular table.  In 2000 Query
Analyzer, I had this set up as a keyboard shortcut, and it worked fine......I
could just highlight any table in my script, hit the shortcut, and presto!

But it looks as though you can no longer do this in 2005 Mgmt Studio.  Am I
correct - or am I missing something?

Author
1 Mar 2007 10:35 PM
Erland Sommarskog
CadeBryant (CadeBry***@discussions.microsoft.com) writes:
Show quote
> Unlike SQL 2000 Query Analyzer, in SQL 2005 Management Studio, it appears
> that you cannot configure a keyboard shortcut command to trigger a
> user-defined stored procedure.
>
> For example, if I set Ctrl+3 to trigger a system proc such as
> sp_helptext, it works.  But if I set it to trigger a user proc, it
> doesn't work.  I have a proc called sp_tablesample, which returns the
> top 100 rows of the table name that's passed in as a parameter.  This is
> very helpful for when I need to get a quick view of the type of data
> that's in a particular table.  In 2000 Query Analyzer, I had this set up
> as a keyboard shortcut, and it worked fine......I could just highlight
> any table in my script, hit the shortcut, and presto!
>
> But it looks as though you can no longer do this in 2005 Mgmt Studio.
> Am I correct - or am I missing something? 

I was able to do it. However, it did not work in the current query window,
only in new windows that I opened later.


--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

AddThis Social Bookmark Button