June 21, 2008 at 8:18 am
Hello All
I trying to figure out how I can enable a shortcut feature in SQL Server 2005 Management Studio Query window, whereby, when I am typing a query on an object, it will automatically filter, and display a list of possible object names which may be what i want.
For example if im working on the northwind database and i type SELECT * FROM C.........., it will display all the table objects with the letter C, in a drop down list format for me to select which particular object I am looking for.
Can anyone help?
June 21, 2008 at 8:50 am
This does not exist natively in SSMS 2005. It does exist in SSMS 2008 - but Microsoft has modified the latest version (RC0) to exclude the capability when accessing a prior version (in other words, you only get Intellisense when using SSMS 2008 against a 2008 instance).
Other products are available as add-ins. Search for SQL Prompt which is one of the better ones available.
Jeff
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 21, 2008 at 9:56 am
The advice above is correct. As far as I know, only SQL Prompt from Red GATE can do this in 2005.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy