Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Prompt Tips #1 - Selecting in the Object Explorer Expand / Collapse
Author
Message
Posted Wednesday, May 7, 2014 1:28 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:03 PM
Points: 33,942, Visits: 18,048
Comments posted to this topic are about the item SQL Prompt Tips #1 - Selecting in the Object Explorer






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1568670
Posted Friday, May 9, 2014 5:28 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, June 22, 2016 12:30 PM
Points: 302, Visits: 197
Good Morning.

How may I configure this shortcut?

Thanks.
Post #1569213
Posted Friday, May 9, 2014 9:13 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:03 PM
Points: 33,942, Visits: 18,048
There is no configuration. This is already set if you use SQL Prompt. If you don't have SQL Prompt, then I don't know how this would work.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1569334
Posted Friday, May 23, 2014 7:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, February 2, 2016 4:03 AM
Points: 10, Visits: 62
Hi Steve

This sounds like a really useful tip, but what should I look for if it doesn't work?
Ctrl/F12 does absolutely nothing, yes I do have SQL Prompt installed and it works fine when prompting.
(SSMS 11.0.3000.0)

Thanks
Adrian
Post #1573993
Posted Friday, May 23, 2014 12:40 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:03 PM
Points: 33,942, Visits: 18,048
That's a tough question. I'd contact support. It's possible you have a key overload of some sort, based on your environment. Do you have Prompt 6? I think 6.3 is the latest incremental build.

You can post a note here: http://www.red-gate.com/messageboard/viewforum.php?f=169 or click the contact support item.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1574195
Posted Friday, May 23, 2014 12:40 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:03 PM
Points: 33,942, Visits: 18,048
found this as well: http://www.red-gate.com/messageboard/viewtopic.php?t=19630&highlight=ctrl+f12






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1574196
Posted Wednesday, October 14, 2015 2:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 26, 2015 9:53 AM
Points: 9, Visits: 122
Only works for me if I highlight the object name and that name is not in brackets.
Post #1727718
Posted Wednesday, October 14, 2015 3:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, February 2, 2016 4:03 AM
Points: 10, Visits: 62
it's working fine now, dunno what happened the previous time
Thanks for the help
Post #1727723
Posted Wednesday, October 14, 2015 7:43 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 21, 2016 3:38 PM
Points: 204, Visits: 672
I am a huge fan of Sql Prompt. Prior it seemed i would manage to memorize most of the database for quick querying.

Do you know of a method to copy to pasteboard the quick text from sql prompt?
EX: typing an exec stored procedure or select from a table a pause allows sql prompt to show the DDL.

A short cut key to copy that code w/o taking hands off of the keyboard and using the mouse to click to copy button would be fantastic.

thanks
daryl
Post #1727817
Posted Wednesday, October 14, 2015 9:15 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, June 24, 2016 8:27 AM
Points: 94, Visits: 452
This function will silently fail (no error msg) if the object you are searching for is new and does not yet appear in the object tree. Refreshing the tree may be necessary after creating an object. That would explain why it appeared to fail, but then later worked.
Post #1727863
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse