Re: Number of SQL Server logins

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 12/27/04

  • Next message: Adam Machanic: "Re: Did sqlwish@ go swish?, say it ain't so!" 
    Date: Mon, 27 Dec 2004 22:21:30 +0100

    Hi

    Yes you are right.....my head has been a bit too much in Sybase today.

    Busy writing some scripts to test what really happens when the 2 tables hit
    their limits.

    Cheers
    --------------------------------
    Mike Epprecht, Microsoft SQL Server MVP
    Zurich, Switzerland

    IM: mike@epprecht.net

    MVP Program: http://www.microsoft.com/mvp

    Blog: http://www.msmvps.com/epprecht/

    "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
    message news:OaEph9D7EHA.2572@tk2msftngp13.phx.gbl...
    > > In userdatabase.dbo.sysusers, uid is a smallint, so 32'767 would be the
    > > limit per database.
    >
    > However, roles are also stored in sysusers, cutting down number of users
    to half. Below is a line
    > from sp_grantdbaccess:
    >
    > where uid >= 5 and uid < (16384 - 1) -- stay in users range
    >
    >
    > --
    > Tibor Karaszi, SQL Server MVP
    > http://www.karaszi.com/sqlserver/default.asp
    > http://www.solidqualitylearning.com/
    > http://www.sqlug.se/
    >
    >
    > "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
    > news:257A5B67-9708-4FA0-B58C-897000078781@microsoft.com...
    > > Hi
    > >
    > > Can't find documentation, but master.dbo.syslogins does not use a
    counter.
    > > Good so far. Limitation here is number of unique combinations of
    charaters
    > > that fit into "name" which is nvarchar(128)
    > >
    > > In userdatabase.dbo.sysusers, uid is a smallint, so 32'767 would be the
    > > limit per database.
    > >
    > > So, it looks like only a per DB limit. Think it is time for me to do a
    bit
    > > of an experiment.
    > >
    > > Regards
    > > Mike
    > >
    > > "Oscar" wrote:
    > >
    > >> Is there a limit on how many SQL logins can be created on an instance?
    If
    > >> so, where is this documented? Thanks in advance.
    > >>
    > >> Oscar
    >
    >

  • Next message: Adam Machanic: "Re: Did sqlwish@ go swish?, say it ain't so!"

    Relevant Pages

    • Re: Move Logs to Another Drive
      ... Mike Epprecht, Microsoft SQL Server MVP ... > log after a database has been created. ...
      (microsoft.public.sqlserver.setup)
    • Re: about automation tool
      ... party tool which is useful for running all object scripts at one time " OR " ... SQL Server MVP ... I am working on a sqlserver2005 database. ...
      (microsoft.public.sqlserver.security)
    • Re: Generate database ...
      ... Right-click the database, Tasks, Generate Scripts. ... Tibor Karaszi, SQL Server MVP ... Is there a way (in SQL Server 2005) to generate the script to create: ...
      (microsoft.public.sqlserver.tools)
    • Re: Cluster Service remain on starting state after quorum log corr
      ... > You have to ask Microsoft Product Support for the Fix. ... > Mike Epprecht, Microsoft SQL Server MVP ... >>> Mike Epprecht, Microsoft SQL Server MVP ...
      (microsoft.public.sqlserver.clustering)
    • Re: Database recovery with data file only
      ... Basically using that command breaks your business logic as there's no ... "Dan Guzman" wrote in message ... >> database Backup as well as ... >>> SQL Server MVP ...
      (microsoft.public.sqlserver.server)