INNER JOIN sysusers ON sysobjects.uid = sysusers.uid */. is_disabled FROM sys.triggers WHERE parent_class_desc = 'OBJECT_OR_COLUMN' ORDER BY OBJECT_NAME(parent_id), Name

  stackoverflow.com

  dba.stackexchange.com

SELECT name FROM sysusers SELECT name FROM sys.procedures; -- with INFORMATION_SCHEMA

  alberton.info

Schemas include default db_* , sys, information_schema and guest schemas. select s.name as schema_name, s.schema_id, u.name as schema_owner from sys.schemas s inner join sys.sysusers u.

  dataedo.com

SELECT * FROM information_schema.PROCESSLIST WHERE COMMAND != 'Sleep' AND TIME > 4. How many processes per user? SELECT SUBSTR(HOST, 1, LOCATE(':',HOST)-1) AS hostname, COUNT(*) FROM information_schema.PROCESSLIST GROUP BY hostname.

  code.openark.org

-- доменный юзер SELECT * FROM sys.sysusers --- 22 записи. Нету части моих датабазе ролей. в обычной не базе создайте бесправного юзера и убедитесь, что он прекрасно видит fixed database roles, если опрашивает sysusers

  murcode.ru

  www.rldp.ru

  www.mssqltips.com

  learn.microsoft.com

  github.com

Page generated - 0.2588448524 (55c36b17045939fe4a93b371aaaf529d)