Unable to see the Query Analyzer in installed SQL Server 2005 Developer Edition - The Windows Development Community
in

Unable to see the Query Analyzer in installed SQL Server 2005 Developer Edition

Last post 10-28-2008 9:08 PM by Duncan Priest. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-15-2008 1:23 AM

    Unable to see the Query Analyzer in installed SQL Server 2005 Developer Edition

    Hi, I am trying to install the SQL Server 2005 Developer Edition in my System which is already having .NET software installed. I am unable to see the Query Analyzer in the installed SQL Server. Anyone who are having answer for this, please let me know.

  • 10-28-2008 9:08 PM In reply to

    Re: Unable to see the Query Analyzer in installed SQL Server 2005 Developer Edition

    By now you would already know the answer to this but for the benefit of anyone else with the same issue...

    Query Analyser no longer exists with SQL 2005 or SQL 2008. In it's (& Enterprise Manager's) place, we have SQL Server Management Studio. This tool combines the functions from both previous tools into a the Visual Studio-esque interface. Can take a little getting used to but everyone seems to think its great after a few goes.

    Here's a few tips for the newcomer:

    To display a list of registered servers a la Enterprise Manager, choose View/Registered Servers, or press Ctrl+Alt+G, or there's a button on the toolbar.

    To populate this list from the list you previously built with Enterprise Manager, right click Database Engine in the Registered Servers pane and choose Previously Registered Servers...

    If you really can't handle the tabbed window layout (give it a decent chance before you give up though), you can change this from Tools/Options/Environment/General/Environment Layout - choose MDI environment for a more Query Analyzer feel.

    To edit a DTS package, look under Management/Legacy/Data Transformation Services. You can then right-click on the package and choose Open to open it in the DTS 2000 Package Designer from Enterprise Manager. Oh, and I believe this requires Enterprise Manager to have been installed in order to work. I haven't found any way of creating a new package using this technique though - the simplest thing to do is just to create it in Enterprise Manager. Of course if your databases have all moved to 2005/2008 you should ideally migrate your existing DTS packages and do away with DTS altogether.

    To save the results of a query as ANSI rather than the default of Unicode, use the drop-down arrow on the Save button and choose Save with Encoding…, then select ANSI from the available list. This will have to be done every time (it is not saved as a preference).

    To move from tab to tab use either Ctrl+F6 and Shift+Ctrl+F6 or Ctrl+Tab and Shift+Ctrl+Tab. Unlike other apps that support these keyboard shortcuts, the Tab version not only moves between tabs but displays a preview of available tabs from which you can select with the mouse.

    To move from pane to pane within a tab (ie from the Query to the Results and the Messages) use F6 and Shift+F6.

Page 1 of 1 (2 items)

SPONSORED LINKS FEATURED LINKS

Order Your Fundamentals CD Today!Learn how to use SQL Server, understand Office integration techniques and dive into the essentials of SQL Express and Visual Basic with this free SQL Fundamentals CD. Empower Your Processes with PowerShell 201Paul Robichaux delves deep into PowerShell how-tos in 3 informative lessons, each followed by live Q&A—all on your own computer! Register today! DevConnections, March 22-25, 2009 – Orlando, FLThe first 800 paid attendees receive SQL Server 2008 Standard Edition w/one CAL. Register by January 12 and receive a free night at the JW Marriott (with 3-night stay). For details (203) 268-3204 or 800-438-6720. Join Today: VIP Monthly PassGet online access to ALL of the resources in the Windows IT Pro and SQL Server Magazine network! With your order, you'll also receive a full digital copy of the latest issue of SQL Server Magazine.