Re: Common Objects in Management Studio?

A lot of that functionality can be replaced by templates that you can add
yourself. Open Template Explorer and right-click on the top node, select New
> Template.

Also, if you are just looking for a quick syntax help, you should check
Dynamic Help window. To open it click Help > Dynamic Help menu option. Once
the window opens, you can dock it somewhere in the Management Studio shell.
As you type in an editor, you will see links to help topics that relate to
what you just typed, including syntax help for T-SQL.

Hope that helps.

Regards,
Maciek Sarnowicz
--------------------
SQL Server SDE

This posting is provided "AS IS" with no warranties, and confers no rights




"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns9741F0113F282Yazorman@xxxxxxxxxxxx
> Chase (Chase@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
>> In SQL Query Analyzer's Object Explorer there is a set of Common Objects
>> under all of the DataBase Objects. These were very handy for me when I
>> would forget the syntax for a certain Transact-SQL function. It is more
>> convenient than looking it up in Books Online.
>>
>> I can't seem to find the equivalent of the Common Objects in SQL Server
>> Management Studio. Anyone know where they are?
>
> Welcome to Management Studio! You will find that there is a lot of
> functionality in Query Analyzer and Enterprise Manager that was not
> brought over to Mgmt Studio. No, please don't ask me why! All I can
> suggest
> is go to http://lab.msdn.microsoft.com/ProductFeedback/ and post a
> suggestion for it to come back.
>
> (I will have to admit that this is a feature of Query Analyzer that I
> was not aware of myself.)
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
>
> 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


.

Relevant Pages

  • Re: full-Text Search questions
    ... I will search SQL Server BOL for information. ... TopCo Site / Employees ... The functionality in STS was to search the entire set of sites. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Return subquery rows as one delimited column
    ... and concatenates them together - this will be very slow!! ... For SQL Server 2005, there's a method that uses documented functionality ...
    (comp.databases.ms-sqlserver)
  • Re: I have two questions about the TableAdapter Configuration Wizard
    ... something to do with the difficulty in adding functionality to VS2005. ... Hitchhiker's Guide to Visual Studio and SQL Server ... I want to have a TableAdapter that encapsulates a bunch of stored ... I might have 10 delete sprocs that I want to put into one ...
    (microsoft.public.dotnet.framework.adonet)
  • Switching a Forms Recordsource at RunTime to a SP w/ a Parameter
    ... 2003 and SQL Server 2K) for the past few months, ... then opens the target form. ... Dim cnn As ADODB.Connection ... Dim cmd As ADODB.Command ...
    (microsoft.public.access.adp.sqlserver)
  • RE: access to SQL Server 2.0 CE from .NET Framework
    ... You can use the remote application programming interface to accomplish this functionality of accessing a SQL Server CE database from your ... RAPI allows desktop apps to invoke function calls on your Windows CE device while the device is connected via ActiveSync to the desktop. ... you could write a device resident app which performed SQLCE functionality and call this app from your desktop. ...
    (microsoft.public.sqlserver.ce)