Re: SQL2005 sys tables

Sorry,

I mean in sql2000 query analyzer I can do the select statement against diff
dbs. all i need to do is that I click the dropdown box and change the
database and exec the select statement, It's very simple. Now in sql2005. I
need to run a select statement in one db only. no drropdown box to select db
in the same query analyzer window,


Thanks
"Gail Erickson [MS]" <gaile@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:OR6NC2BVGHA.6112@xxxxxxxxxxxxxxxxxxxxxxx
One more question, In sql2000 I can run query analyzer and in the same
window i could change the the dbs in the server.
In sql2005, I couldn't WHY?

Sorry, I don't understand the question. Can you try again and if you are
getting an error message, please include the exact error message text.

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

"mecn" <mecn2002@xxxxxxxxx> wrote in message
news:e4$lmRAVGHA.6112@xxxxxxxxxxxxxxxxxxxxxxx
Thanks,
One more question, In sql2000 I can run query analyzer and in the same
window i could change the the dbs in the server.
In sql2005, I couldn't WHY?

THnaks

"mecn" <mecn2002@xxxxxxxxx> wrote in message
news:uEK5Zo3UGHA.5552@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

In sql2005, I don't a lot of sys tables in master db.
i.e. sysusers and syslogins?

ANy ideas?

Thanks







.

Relevant Pages

  • Re: SQL2005 sys tables
    ... In sql2000 I can run query analyzer and in the same ... window i could change the the dbs in the server. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL2005 sys tables
    ... window i could change the the dbs in the server. ... getting an error message, please include the exact error message text. ... SQL Server Documentation Team ...
    (microsoft.public.sqlserver.security)
  • Re: Move 10 DBs and provide dev access thru EM?
    ... DBs open. ... "Dan Guzman" wrote: ... need to stop SQL Server. ... the process using the database files. ...
    (microsoft.public.sqlserver.security)
  • Re: Filemaker Server Pro / Pro Advanced Security
    ... Filemaker Server Pro 7.04. ... the school also has some DBs running on the same server. ... all Filemaker users have been using FMPro to access ...
    (comp.databases.filemaker)
  • Re: SQL 7.0: Beim Erstellen einer SP ANSI_NULLS und ANSI_WARNINGS Fehler
    ... Dirk Soetebeer schrieb ... ... > es sollen Daten von einem Verknüpften Server via SP geladen werden. ... > Beim Ausführen in Query Analyzer funktioniert alles ordnungsgemäß. ...
    (microsoft.public.de.sqlserver)