|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL 2005 Management Studio - no more user-defined keyboard shortcuUnlike 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? CadeBryant (CadeBry***@discussions.microsoft.com) writes:
Show quote > Unlike SQL 2000 Query Analyzer, in SQL 2005 Management Studio, it appears I was able to do it. However, it did not work in the current query window,> 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? 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 |
|||||||||||||||||||||||