Re: Default database in Query Analyzer

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/14/04 

Date: Sat, 14 Feb 2004 07:49:14 -0500

If they don't have a Login then how do they connect to SQL Server? 

-- 
Andrew J. Kelly
SQL Server MVP
"Mark Goldin" <markgoldin@comcast.net> wrote in message
news:uozJ1iu8DHA.2168@TK2MSFTNGP12.phx.gbl...
> But that user does not have a login name.
> What do I do?
>
> "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
> news:ejq3C8i8DHA.2416@TK2MSFTNGP10.phx.gbl...
> > You could associate your login with a default database, so that when you
> > login, you directly go to that database.See sp_defaultdb in SQL Server
> Books
> > Online.
> > -- 
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Mark Goldin" <markgoldin@comcast.net> wrote in message
> > news:ehw%23Hui8DHA.2736@TK2MSFTNGP10.phx.gbl...
> > How can I set default database to open QA with?
> >
> >
> >
>
>

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: cannot login to the db after...
    ... Jasper Smith (SQL Server MVP) ... I have created a new database, "db_1", using the "sa" ... I then created a new login, "sqluser1" and gave ...
    (microsoft.public.sqlserver.security)
  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)
  • Re: problem with query moving data from 1 dbase to another.
    ... You register a SQL Server instance, where such an instance can have several databases. ... Tibor Karaszi, SQL Server MVP ... > you know how to connect to an existing database, ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: error 80020009 HELP!!!
    ... Check your SQL Server event logs for any problems. ... Mike Epprecht, Microsoft SQL Server MVP ... > when they try to access the database through a web browser. ... > info by performing a database restore? ...
    (microsoft.public.sqlserver.server)