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