Post reply

hidden system tables

  • March 3, 2005 at 1:47 pm

    #92613

    In both EM and QA master.dbo.syslogins does not appear in the object browser, yet it can be queried in QA like this "select blah, blah from master.dbo.syslogins" and return recorde. Are there other system tables that contain valuable information that are hidden in the object browsers?

    Cody Pack
    MCSE Windows 2000
    MCDBA SQL Server 2000

  • March 3, 2005 at 2:05 pm

    #545333

    select * from sysobjects where type = 'S'

  • March 3, 2005 at 2:10 pm

    #545334

    Thanks for the input, if I execute this in QA

    select [name] from master.dbo.sysobjects where type = 'S' order by [name]

    I get

    sysaltfiles

    syscacheobjects

    syscharsets

    syscolumns

    syscomments

    sysconfigures

    syscurconfigs

    syscursorcolumns

    syscursorrefs

    syscursors

    syscursortables

    sysdatabases

    sysdepends

    sysdevices

    sysfilegroups

    sysfiles

    sysfiles1

    sysforeignkeys

    sysfulltextcatalogs

    sysfulltextnotify

    sysindexes

    sysindexkeys

    syslanguages

    syslockinfo

    syslocks

    sysmembers

    sysmessages

    sysobjects

    sysperfinfo

    syspermissions

    sysprocesses

    sysproperties

    sysprotects

    sysreferences

    SYSREMOTE_CATALOGS

    SYSREMOTE_COLUMN_PRIVILEGES

    SYSREMOTE_COLUMNS

    SYSREMOTE_FOREIGN_KEYS

    SYSREMOTE_INDEXES

    SYSREMOTE_PRIMARY_KEYS

    SYSREMOTE_PROVIDER_TYPES

    SYSREMOTE_SCHEMATA

    SYSREMOTE_STATISTICS

    SYSREMOTE_TABLE_PRIVILEGES

    SYSREMOTE_TABLES

    SYSREMOTE_VIEWS

    sysservers

    systypes

    sysusers

    sysxlogins

    syslogins is not in the list???????

    Cody Pack
    MCSE Windows 2000
    MCDBA SQL Server 2000

  • March 3, 2005 at 2:11 pm

    #545335

    DOH!!!!

    syslogins is a view.....

    I will paint an "L" on my forehaed for the rest of the day!!

    Cody Pack
    MCSE Windows 2000
    MCDBA SQL Server 2000

  • March 4, 2005 at 12:39 am

    #545394

    I will paint an "L" on my forehaed for the rest of the day!!

    Bear with me, since I am a non-native english speaker.

    What does this mean?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • March 4, 2005 at 6:33 am

    #545441

    Frank,

    He was joking. The letter L represents the word LOSER, which in this case means "someone who fails consistently, especially a person with bad luck or poor skills". The usage here is American slang.

     

  • March 4, 2005 at 6:44 am

    #545445

    < vbg >

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • March 4, 2005 at 1:14 pm

    #545567

    A mildly entertaining ("after a few beers" funny, I mean) movie by the same name :

    http://www.imdb.com/title/tt0217630/

    And remember that Beck song?

    Signature is NULL

  • March 4, 2005 at 7:48 pm

    #545607

    for your pleasure and amusment, i have correctly identified my self in my avatar

    Cody Pack
    MCSE Windows 2000
    MCDBA SQL Server 2000

  • March 17, 2005 at 4:29 am

    #547492

     

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply