May 26, 2011 at 4:32 pm
Greetings all,
So the default shortcut keys to use, Alt+F1 for sp_help for instance (I am running SQL Server 2008 enterprise sp2) is fine and dandy in most situations to highlight a table or various database object and execute to get some helpful information about said object. However, I have a database that uses a few schemas which are not the default dbo schema. As most of us are aware, you must schema qualify anything that is not the default schema (usually dbo). From what I gather, highlighting a database object and hitting Alt+f1 only works on non-schema qualified objects in the default schema. It does work however by putting the schema qualified object in quote strings. For instance selecting 'schema.table' and hitting Alt+f1 works (assuming you have a schema.table object in your db) however, this effectively removes the convenience of having a hotkey you can execute on the fly.
I have tried making my own stored procs that pass the input into string quotations but it does not work. So my question is; is there anyway around this type of situation without having to put things in quotations?
Link to my blog http://notyelf.com/
May 27, 2011 at 12:40 am
Refer the below link for the same and vote for it....
Also there is a solution, try with if it suits your req...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply