Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Scroll ignore

scroll-viewport	true
scroll-pdf	true
scroll-office	true
scroll-chm	true
scroll-docbook	true
scroll-eclipsehelp	true
scroll-html	true
scroll-epub	true

Open in new tab

About Collectors

Insert excerpt

	Collector Method
	Collector Method
name	about

...

INFORMATION_SCHEMA.ROUTINES
INFORMATION_SCHEMA.VIEWS
INFORMATION_SCHEMA.TABLE_CONSTRAINTS
INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
INFORMATION_SCHEMA.TABLES
INFORMATION_SCHEMA.COLUMNS
INFORMATION_SCHEMA.VIEWS
sys.foreign_key_columns
sys.objectobjects
sys.tables
sys.schemas
sys.columns
VIEW SERVER STATE permission on the server
- Required for Extended Event log

VIEW Definition

All databases

Code Block
USE master GO GRANT VIEW ANY DEFINITION TO Kadauser

Selected databases. Repeat for each database

Code Block
USE <REPLACE WITH A DATABASE> GO GRANT VIEW ANY DEFINITION TO Kadauser

...