RE: Enterprise Manager Shortcuts for Remote Servers

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Julian Forniss (JulianForniss_at_discussions.microsoft.com)
Date: 01/14/05 

Date: Fri, 14 Jan 2005 12:21:04 -0800

Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.

Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.

"Yogish" wrote:

> Hi Julian,
>
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
>
> ---------
> Thanks
> Yogish

Relevant Pages

  • Linked Server Problem
    ... I have a view to a table in a linked server (an Access mdb ... file) that works fine in Enterprise Manager and Query ... Analyzer, but when the view is executed in the Access adp ...
    (microsoft.public.access.adp.sqlserver)
  • RE: HOWTO programmtically code use in T-SQL
    ... Analyzer, you are connecting to a server, so switching databases at will is ... a specific database where USE has no meaning. ... > How can one programmticaly code the 'use' statement in T-SQL so that from> both Query Analyzer and a typical ADO/ODBC query one can change whatever DB a> TX is "pointed" to to "point" to the DB they really want to work work. ...
    (microsoft.public.sqlserver.programming)
  • Re: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)
  • Re: ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor
    ... My first suggestion is that you really should be using Query ... Analyzer for those types of activities. ... >using Enterprise manager and when changing colum name I get this error. ... >>>I am trying to rename a column name and it gives me the following error. ...
    (microsoft.public.sqlserver.odbc)
  • Re: stored procedure update HUGE PROBLEM
    ... Don't ever create or alter procs in Enterprise Manager. ... Use Query ... Analyzer and specify SET QUOTED_IDENTIFIER and ANS_NULLS ON or OFF as ...
    (comp.databases.ms-sqlserver)