| Server IP : 180.180.241.3 / Your IP : 216.73.216.252 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /Program Files/Microsoft SQL Server/MSSQL11.MSSQLSERVER/MSSQL/Binn/ |
Upload File : |
c ) 9 o87 0 1 . /3==CSSSSSSScccmw)Ud}Kޟ& @ @ ?v%Oqn Z l o g u\{. m s s q l s y s t e m r e s o u r c e & n A " A "
k a W@<(± *= W@<(± c o 4rtH5y34W Q C u\{. m s s q l s y s t e m r e s o u r c e & n q 2 q 2 k a W@<(± *= W@<(± c o 4rtH5y34W Q C @u\{. m s s q l s y s t e m r e s o u r c e & n q 2 q 2 k a W@<(± *= W@<(± c o 4rtH5y34W Q C u\{. m s s q l s y s t e m r e s o u r c e & n A " A "
k a W@<(± *= W@<(± c A" 4rtH5y34W Q C Q C I` # K L . p 0 ` K k F
K 5 - =
K A R c 6 A S A T
A U
A V
A W
A X
A Y A Z
A [
A \
A ]
A ^
A _
A ` A a A b A c A d
A e A f
A g A h A i A j A k A l A m A n A o ! A p " JII@HpGFE E0D`CBA@ @P?>=<<@;p:98 807`6543 3P210P00 R L 6 l 0 0 7 4o$ 0 8 % L F 3 ς F S h r i n k F i l e 8 F 8 F 0
9 ;% > c K ))
0 1 . /3==CSSSSSSScccmw)Ud}Kޟ& @
@ @ ?v%Oqn Z l o g 0 1 . /3==CSSSSSSScccmw)Ud}Kޟ& @ @ ?v%Oqn Z l o g 0
> ;$
P 8 F 8 ς 0 ^ ? pVƼ L F 3 Ђ F F i l e S i z e > ? F K
aj@ @ ? F %% ? 0 @ ]$ P ? F ? Ђ 0 " A !
5 - =
A R # A S A A T A
A U A
A V A
A W A
A X A A Y A A Z A
A [ A
A \ A
A ] A
A ^ A
A _ A
A ` A A a A A b A A c A A d A
A e A A f A
A g A A h A A i A A j A A k A A l A A m A A n A A o A A p A ` X F 0` P@p 0
`
P@p 0 R O 0 ς F S h r i n k F i l e 8 F 8 F 0 P O` A " Y A " 0 3==CSSSSSSScccmw)Ud}Kޟ& @
@ @ ?v%Oqn Z l o g Q ٕUQ L F 3 ! F ( D B M g r : : C h a n g e D B S t a t e > Q F c C! $ @ 0 R } ^E > Q F c Q r : 0 C h a n g e D B S t a t e > Q F c C! $ @ 0 z S n^VQ @ R F (% Q 0 r : 0 C h a n g e D B S t a t e > Q F c C! $ @ 0 T )Q P Q F Q ! 0 r : 0 C h a n g e D B S t a t e > Q F c C! $ @ 0 H U ʷ> L F 3 Q F , C R E A T E / A L T E R P R O C E D U R E > U F =P > U F t "
! " P 0 0 =P P P s p _ a u t o s t a t s "
P* > U F ] " &! " & & =P & s p _ a u t o s t a t s "
ƹ̠ > U F " &!
" & & =P & s p _ a u t o s t a t s "
K9~ > U F z " &! "
=P "
[ > U F < & <
0 =P
8 create procedure sys.sp_autostats
@tblname nvarchar(776),
@flagc varchar(10)=null,
@indname sysname=null
as
begin
declare @fag bit, -- no recompute
@permit bit, -- locked after permission check?
@tabid int,
@objtype varchar(2)
-- Check flag
set @flag = (case lower(@flagc)
when 'on' then 0
when 'off' then 1
end)
if @flag is null AND @flagc is NOT null
begin
raiserror(17000,-1,-1)
return (1)
end
-- set NORECOMPUTE mask
select @permit = 1
-- Check we are executing in the correct database
declare @db sysname
select @db = parsename(@tblname, 3)
if (@db is NOTnull AND @db <> db_name())
begin
raiserror(15387,-1,-1)
return (1)
end
-- VERIFY WE HAVE A USER-TABLE/INDEXED-VIEW BY THIS NAME IN THE DATABASE
select @tabid = object_id, @objtype = type from sys.objects
where object_id = object_id(@tblname, 'local') and (type = 'U' or type = 'V' or type = 'IT')
if (@tabid is null) OR
(
@objtype = 'V' AND
(ObjectProperty(@tabid, 'IsIndexed') = 0 OR
ObjectProperty(@tabid, 'IsMSShipped') = 1)
)
begin
raiserror(15390,-1,-1,@tblname)
return @@error
end
-- PRINT or UPDATE status?
if (@flag is null)
begin
-- Display global settings (sp_dboption)
--
PRINT 'Global statistics settings for ' + quotename(db_name(), '[') + ':'
PRINT ' Automatic update statistics: ' + (case when DatabasePropertyEx(db_name(), 'IsAutoUpdateStatistics') = 1 then 'ON' else 'OFF' end)
PRINT ' Automatic create statistics: ' + (case when DatabasePropertyEx(db_name(), 'IsAutoCreateStatistics') = 1 then 'ON' else 'OFF' end)
PRINT ''
-- Display the current status of the index(s)
--
PRINT 'settings for table ' + quotename(@tblname, '[')
PRINT ''
select 'Index Name' = quotename(s.name, '['),
'AUTOSTATS' = case s.no_recompute
when 1 then 'OFF'
else 'ON'
end,
'Last Updated' = stats_date(@tabid, s.stats_id)
from sys.stats s
where s.object_id = @tabid AND -- Table
case -- Match name
when @indname is null then 1
when @indname = s.name then 1
else 0
end = 1
end
else
begin
BEGIN TRANSACTION
-- Lock the table schema and check permissions
EXEC %%Object(MultiName = @tblname).LockMatchID(ID = @tabid, Exclusive = 1, BindInternal = 1)
if (@@error <> 0)
begin
COMMIT TRANSACTION
raiserror(15165,-1,-1,@tblname)
return @@error
end
-- Flip the status bits
if (@indname is null) -- Match all index
begin
declare ms_crs_autostat cursor local static for
select s.name
from sys.stats s left outer join sys.indexes i on s.object_id] = i.[object_id] and s.[stats_id] = i.[index_id]
where s.[object_id] = @tabid and isnull(i.is_hypothetical, 0) = 0
open ms_crs_autostat
fetch next from ms_crs_autostat into @indname
while @@fetch_status = 0
begin
EXEC %%StatisticsEx(ObjectID = @tabid, Name = @indname).SetNoRecompute(Value = @flag)
fetch next from ms_crs_autostat into @indname
end
deallocate ms_crs_autostat
end
else
begin
if exists(select *
from sys.stats
whereobject_id = @tabid and name = @indname)
EXEC %%StatisticsEx(ObjectID = @tabid, Name = @indname).SetNoRecompute(Value = @flag)
else
begin
COMMIT TRANSACTION
raiserror(15323,-1,-1,@tblname)
return @@error
end
end
COMMIT TRANSACTION
end
return(0) -- sp_autostats
end
<
'8ө > U F k )
! ) E 0 - =P E @ t b l n a m e )
x / > U F ) ) " 6=P " @ t b l n a m e )
ɮs > U F k ) U ) A 0 - =P
A @ f l a g c )
L) > U
F ) U ) 6=P @ f l a g c )
s > U F k ) U
) E 0 - =P E @ i n d n a m e )
aX̟ > U F ) U ) " 6=P " @ i n d n a m e )
s > U
F t " U " =P "
P* > U F t " U " =P "
P* P U F U Q XX0 X 0 [
l a L F 3 N _ F , C R E A T E / A L T E R P R O C E D U R E > a F z > a F t " U " T 0 0 z P N N T s p _ u p d a t e s t a t s "
<LÃg> > a F ] " " " * =& z * s p _ u p d a t e t a t s "
eww > a F ^ ! " & " * s & z * s p _ u p d a t e s t a t s "
v{
C > a F z " U "
z "
^
> a F < J < 0 z 8
create procedure sys.sp_updatestats
@resample char(8)='NO'
as
declare @dbsid varbinary(85)
select@dbsid = owner_sid
from sys.databases
where name = db_name()
-- Check the user sysadmin
if not is_srvrolemember('sysadmin') = 1 and suser_sid() <> @dbsid
begin
raiserror(15247,-1,-1)
return (1)
end
-- cannot execute against R/O databases
if DATABASEPROPERTYEX(db_name(), 'Updateability')=N'READ_ONLY'
begin
raiserror(15635,-1,-1,N'sp_updatestats')
return (1)
end
if upper(@resample)<>'RESAMPLE' and upper(@resample)<>'NO'
begin
raiserror(14138, -1, -1, @resample)
return (1)
end
-- required so it can update stats on ICC/IVs
set ansi_warnings on
set ansi_padding on
set arithabort on
set concat_null_yields_null on
set numeric_roundabort off
declare @exec_stmt nvarchar(4000) -- "UPDATE STATISTICS [sysname].[sysname] [sysname] WITH RESAMPLE NORECOMPUTE"
declare @exec_stmt_head nvarchar(4000) -- "UPDATE STATISTICS [sysname].[sysname] "
declare @options nvarchar(100) -- "RESAMPLE NORECOMPUTE"
declare @index_names cursor
declare @ind_nae sysname
declare @ind_id int
declare @ind_rowmodctr int
declare @updated_count int
declare @skipped_count int
declare @sch_id int
declare @schema_name sysname
declare @table_name sysname
declare @table_id int
declare @table_type char(2)
declare @schema_table_name nvarchar(640) -- assuming sysname is 128 chars, 5x that, so it's > 128*4+4
declare @compatlvl tinyint
declare ms_crs_tnames cursor local fast_forward read_only for
select name, object_id, schema_id, type from sys.bjects o
where o.type = 'U' or o.type = 'IT'
open ms_crs_tnames
fetch next from ms_crs_tnames into @table_name, @table_id, @sch_id, @table_type
-- determine compatibility level
select @compatlvl = cmptlevel from sys.sysdatabases where name = db_name()
while (@@fetch_status <> -1) -- fetch successful
begin
-- generate fully qualified quoted name
select @schema_name = schema_name(@sch_id)
select @schema_table_name = quotename(@schema_name, '[') +'.'+ quotename(rtrim(@table_name), [')
-- check for table with disabled clustered index
if (1 = isnull((select is_disabled from sys.indexes where object_id = @table_id and index_id = 1), 0))
begin
-- raiserror('Table ''%s'': cannot perform the operation on the table because its clustered index is disabled', -1, -1, @tablename)
raiserror(15654, -1, -1, @schema_table_name)
end
else
begin
-- filter out local temp tables and Hekaton tables
-- Note that OBJECTPROPERTY returns NULL on type="IT" tables, thus we nly call it on type='U' tables
if ((@@fetch_status <> -2) and
(substring(@table_name, 1, 1) <> '#') and -- temp tables
((@table_type<>'U') or (0 = OBJECTPROPERTY(@table_id, 'TableIsInMemory')))) -- Hekaton tables
begin
-- reset counters for this table
select @updated_count = 0
select @skipped_count = 0
-- print status message
--raiserror('Updating %s', -1, -1, @schema_table_name)
raiserror(15650, -1, -1, @schema_table_name)
-- initial statementpreparation: UPDATE STATISTICS [schema].[name]
select @exec_stmt_head = 'UPDATE STATISTICS ' + @schema_table_name + ' '
-- using another cursor to iterate through
-- indices and stats (user and auto-created)
set @index_names = cursor local fast_forward read_only for
select name, indid, rowmodctr from sys.sysindexes
where id = @table_id and indid > 0 and indexproperty(id, name, 'ishypothetical') = 0
order by indid
open @index_names
fetch @index_names into ind_name, @ind_id, @ind_rowmodctr
-- if there are no stats, skip update
if @@fetch_status < 0
--raiserror(' %d indexes/statistics have been updated, %d did not require update.', -1, -1, @updated_count, @skipped_count)
raiserror(15651, -1, -1, @updated_count, @skipped_count)
else
begin
while @@fetch_status >= 0
begin
-- create quoted index name
declare @ind_name_quoted nvarchar(258)
select @ind_name_quoted = quotename(@ind_name, '[')
-- reset options
select @options = ''
declare @is_ver_current bit
select @is_ver_current = stats_ver_current(@table_id, @ind_id)
-- note that <> 0 should work against old and new rowmodctr logic (when it is always > 0)
-- also, force a refresh if the stats blob version is not current
if ((@ind_rowmodctr <> 0) or ((@is_ver_current is not null) and (@is_ver_current = 0)))
begin
select @exec_stmt = @exec_stmt_head + @ind_name_quoted
- add resample if needed
if (upper(@resample)='RESAMPLE') select @options = 'RESAMPLE '
if (@compatlvl >= 90)
-- put norecompute if local properties are set to AUTOSTATS = OFF
-- note that ind name is unique within the object
if ((select no_recompute from sys.stats where object_id = @table_id and name = @ind_name) = 1)
begin
if (len(@options) > 0) select @options = @options + ', NORECOMPUTE'
else select @options = 'NORECOMPUTE'
end
if (len(@options) > 0)
select @exec_stmt = @exec_stmt + ' WITH ' + @options
--print @exec_stmt
exec (@exec_stmt)
--raiserror(' %s has been updated...', -1, -1, @ind_name_quoted)
raiserror(15652, -1, -1, @ind_name_quoted)
select @updated_count = @updated_count + 1
end
else
begin
--raiserror(' %s, update is not necessary...', -1, -1, @ind_name_quoted)
raiserror(15653, -1, -1, @ind_name_quoted)
select @skipped_count = @skipped_count + 1
end
fetch @index_names into @ind_name, @ind_id, @ind_rowmodctr
end
--raiserror(' %d index(es)/statistic(s) have been updated, %d did not require update/disabled.', -1, -1, @updated_count, @skipped_count)
raiserror(15651, -1, -1, @updated_count, @skipped_count)
end
deallocate @index_names
end
end
print ' '
fetch next from ms_crs_tnames into @table_name, @table_id, @sch_id, @table_type
end
raiserrr(15005,-1,-1)
deallocate ms_crs_tnames
return(0) -- sp_updatestats
<
}Yn > a F c ) ) G 0 - z G @ r e s a m p l e )
c7 > a F k ) U
) $ 6z $ @ r e s a m p l e )
"
T > a F t " a " z "
<LÃg > a
F t " a
" z "
<LÃg P a F N a _ h (( 0 o
- @ o'om
s , . q L'̾ L F 3 f F , C R E A T E / A L T E R P R O C E D U R E > q F > q F i % " ! " T 0 0 P T s p _ c r e a t e s t a t s "
q> > q F ] " U " * =& * s p _ c r e a t e t a t s "
!@ > q F " U " * s & * s p _ c r e a t e s t a t s "
-2d% > q F z " a "
"
Gބ > q F < cK c
Dz
@ q F < P q F < m sys. > q F < q < A f e& me < > q
F < q
< A h
create procedure sys.sp_createstats
@indexonly char(9)= 'NO', -- Optional 'INDEXONLY' text - if present, then only the columns
-- covered by indexes are subject of statistics creation
@fullscan char(9)= 'NO', -- Optional 'FULLSCAN' text - if present, then the statistics
- will be created with full scan rather than sampling
@norecompute char(12)= 'NO' -- Optional 'NORECOMPUTE' text - if present, then statistics
-- will not be updated automatically
as
-- NOTE: This sp will create statistics for *all* columns of all tables
-- which the user has the privilege to create stats on (sysadmin, dbo, owner).
-- The following columns are not considered
-- - first column of an index
-- - column which already has statistics
-- - XML column
-- - filestream clumn
-- - sparse column in a wide-table (a table with a sparse column set)
-- - nondeterministic computed columns
-- - imprecise computed columns
declare @sysadmin int
,@dbname sysname
select @indexonly = UPPER (@indexonly collate Latin1_General_CI_AS)
-- Validate input options
if (@indexonly not in ('INDEXONLY', 'NO') OR
UPPER(@fullscan) not in ('FULLSCAN', 'NO') OR
UPPER(@norecompute) not in ('NORECOMPUTE', 'NO'))
begin
raiserror(15600,-1,-1, 'sys.sp_createstats')
retrn @@error
end
-- remember dbname
select @dbname = db_name()
-- create temporary table (column, index position)
create table #colpostab
( col_name sysname collate catalog_default,
col_pos int,
)
set nocount on
-- required for sp_createstats so it can create stats on on ICC/IVs
set ansi_warnings on
set ansi_padding on
set arithabort on
set concat_null_yields_null on
set numeric_roundabort off
declare @exec_stmt nvarchar(4000)
declare @tablename sysname
dclare @columnname sysname
--declare @shortcolumnname sysname
declare @indexname sysname
declare @uid int
declare @indid smallint
declare @position smallint
declare @table_id int
declare @table_type char(2)
declare @schema_name sysname
declare @numcols int -- number of eligible columns found
declare @msg nvarchar(388) -- adding two more chars for msg with 15654
declare @twopart_tablename nvarchar(517)
declare @timestamp varchar(17)
declare @wide_table bit
declare @tablename_eader varchar(267)
declare ms_crs_tnames cursor local static for
select o.name, o.object_id, s.principal_id, s.name, o.type
from sys.objects o
join sys.schemas s on s.schema_id = o.schema_id
where o.type = 'U' or o.type = 'IT'
select @numcols = 0
-- cannot execute against R/O databases
if DATABASEPROPERTYEX(db_name(),N'Updateability')=N'READ_ONLY'
begin
raiserror(15635,-1,-1,N'sp_createstats')
return (1)
end
open ms_crs_tnames
fetch next from ms_crs_tnames into @talename, @table_id, @uid, @schema_name, @table_type
while (@@fetch_status <> -1)
begin
-- check for table with disabled clustered index
if (1 = isnull((select is_disabled from sys.indexes where object_id = @table_id and index_id = 1), 0))
begin
-- raiserror('Table ''%s'': cannot perform the operation on the table because its clustered index is disabled', -1, -1, @tablename)
-- note that we cannot use '%s' in the sqlerrorcodes.h as the same error is reused by sp_create|updatestats and hey have
-- different formatting styles. This style is consistent with the rest of the messages in this SP
select @msg = ''''+ @dbname +'.'+ @schema_name +'.'+ @tablename + ''''
raiserror(15654, -1, -1, @msg)
end
else
begin
-- filter out local temp tables, Hekaton tables, and tables for which current user has no permissions
-- Note that OBJECTPROPERTY returns NULL on type="IT" tables, thus we only call it on type='U' tables
if (
(@@fetch_status <> -2) and
(sbstring(@tablename, 1, 1) <> '#') and -- temp tables
((@table_type<>'U') or (0 = OBJECTPROPERTY(@table_id, 'TableIsInMemory'))) and -- Hekaton table
((is_member('db_owner')=1) or (is_member('ddl_admin')=1) or (is_member(user_name(@uid))=1) or (user_id() = @uid))) -- permissions
begin
select @wide_table = objectproperty(@table_id, 'tablehascolumnset')
-- these are all columns for which the statistics will be created
declare ms_crs_cnames cursor local for select c.name fom sys.columns c
where c.object_id = @table_id
and (type_name(c.system_type_id) not in ('xml'))
and c.name not in (select col_name from #colpostab where col_pos = 1)
and ((c.name in (select col_name from #colpostab)) or (@indexonly <> 'INDEXONLY'))
and (@wide_table=0 or is_sparse=0)
and (is_filestream=0)
and (is_computed = 0
or (is_computed = 1
and columnproperty(@table_id, c.name, 'isdeterministic') = 1
and columnproperty(@table_id, c.name 'isprecise') = 1))
-- populate temporary table of all (column, index position) tuples for this table
truncate table #colpostab
-- for each index on the table, loop though all columns and insert rows
-- open cursor over indexes
declare ms_crs_ind cursor local static for
select stats_id, name from sys.stats
where object_id = @table_id order by stats_id
select @twopart_tablename = quotename( @schema_name , '[')+'.' + quotename( @tablename, '[')
open ms_rs_ind
fetch ms_crs_ind into @indid , @indexname
-- if an index exists
while @@fetch_status >= 0
begin
-- if the index is not disabled and not a columnstore or if there is no entry in sys.indexes for current @indid
-- (we are looking at a statistic not an index) then we need to include the columns of that statistic in #colpostab
if not exists (select * from sys.indexes where object_id = @table_id and index_id = @indid and (is_disabled = 1 or type in (5, 6)))
bgin
-- every index has at least one column at position 1
insert into #colpostab values (index_col(@twopart_tablename,@indid,1),1)
-- now try position 2 and beyond....
select @columnname = index_col(@twopart_tablename, @indid, 2)
select @position = 2
while (@columnname is not null )
begin
insert into #colpostab values (@columnname,@position)
select @position = @position +1
select @columnname = index_col(@twopart_tablename, @indid, position)
end
end
-- next index
fetch ms_crs_ind into @indid , @indexname
end
close ms_crs_ind
deallocate ms_crs_ind
-- now go over all columns which are eligible for creating statistics
-- and are not first columns of any index
-- optionaly we test if they are covered by some index (as non-leading)
open ms_crs_cnames
fetch next from ms_crs_cnames into @columnname
if @@fetch_status < 0
begin
select @msg = @dbnam +'.'+ @schema_name +'.'+ @tablename
raiserror(15013,-1,-1,@msg)
end
else
begin
select @msg = @dbname +'.'+ @schema_name +'.'+ @tablename
raiserror(15018, -1, -1, @msg)
end
while @@fetch_status >= 0
begin
select @numcols = @numcols +1
-- use the column name as the name for the statistics as well
select @exec_stmt = 'CREATE STATISTICS ' + quotename(@columnname, '[') + ' ON ' +
quotename( @schema_name ,'[')+'.' + quotename( @tablenam, '[')+'('+ quotename( @columnname, '[')+')'
-- determining the correct suffix
if ((UPPER(@fullscan) = 'FULLSCAN') AND (UPPER(@norecompute) = 'NORECOMPUTE'))
select @exec_stmt = @exec_stmt + ' WITH FULLSCAN, NORECOMPUTE'
else if (UPPER(@fullscan) = 'FULLSCAN') select @exec_stmt = @exec_stmt + ' WITH FULLSCAN'
else if (UPPER(@norecompute) = 'NORECOMPUTE') select @exec_stmt = @exec_stmt + ' WITH NORECOMPUTE'
EXEC (@exec_stmt)
--print 'Statement='+@exec_stmt
if(@@error = 0) -- otherwise the CREATE STATS will give a me > q F } < R < A e& < > q F } < q < A ssage
print ' ' + @columnname
fetch next from ms_crs_cnames into @columnname
end
close ms_crs_cnames
deallocate ms_crs_cnames
end
end
fetch next from ms_crs_tnames into @tablename, @table_id, @uid, @schema_name, @tabletype
end
print ' '
raiserror(15020,-1,-1,@numcols)
deallocate ms_crs_tnames
if (object_id('[#colpostab]') is not null)
begin
drop table [#colpostab]
end
return(0) -- sp_createstats
> q
F ; < - < D 0 D8 e& h >! } <
7+_ > q F b L ) !
) I 0 - I @ in d e x o n l y )
η > q F & K ) ! ) & 6 & @ i n d e x o n l y )
|͕ > q F b M ) q ) G 0 - G @ f u l l s c a n )
.= V > q F & K ) q ) $ 6 $ @ f u l l s c a n )
ccm > q F N ) q ) M 0 - M @ n o r e c o m p u t e )
Z > q F & M ) q ) * 6 * @ n o r e c o m p u t e )
lI2 > q F i % " q " "
q > q F i % " q " "
q P q F q f ,+(+*)`)(0('&$@$ (( 0 b _ ee@ec,rutbheuo- s . Q L F 3 m F I N V O K E A L T F =P > F t " a " $ " =P "
P* > F k ) U )
=P > )
x / > F k ) ) t =P
)
L) > F k ) ) r a =P )
aX̟ > F t " "
=P "
P*> P F m 088 0 F < P q F < |i/ L F 3 p F I N V O K E A L T F z > F t " " $ N " z "
<LÃg > F c ) a )
z > )
c7 > F t " "
t z "
<LÃg
L P F p r 08 0 )
aX̟ > F t " "
=P "
P*> P F m 088 0 F < P q F < {C L F 3 s F I N V O K E A L T F > F i % " q " $ " "
q > F b L ) q )
> )
η > F b M ) ) t " )
.= VP > F b N ) ) r )
Z > F i % " "
"
q> P F s 088 0 F < P q F < 2 ( * .) 7 A " 5 - = H A " 8 ) 5 ! - ! = I ) N " 5 - = o " "
5 - = " B +! & " B " B
" B
" B " k B
" B
" B " B " 2 B "
B " B " ) O 5 Q - Q = ) B ) B ) B ) B ) B ) B ) B ) B ) B ) B )
B ) B ! ) B " )
B # ) B ! $ ) B " % ) J " 5 - = f " " ' < h 5 j - q = $ ( < O ) < - = @ K < : @ , < : @ - < : @ . < : @ / < @ 0 < ` A " M F (0'`&%$# #P"! @ p 0` P@p 0
`
P@p 0 F b M ) q ) G 0 - G @ f u l l s c a n )
.= V > q F & K ) q ) $ 6 $ @ f u l l s c a n )
ccm > R * 0: 7 0 A " 5 - = H A " 8 rt 2 M 2 0 H A " 8 ,UQ L F 3 у F ( D B M g r : : C h a n g e D B S t a t e > F c R $ @ 0 ]E > F c r : 0 C h a n g e D B S t a t e > F c R $ @ 0 z
UUQ @ F +% 0 r : 0 C h a n g e D B S t a t e > F c R $ @ 0 #Q P F у 0 r : 0 C h a n g e D B S t a t e > F c R $ @ 0 8
q/ L F 3 F " C R E A T E / A L T E R V I E W a e F UpT > F t " " p 0 0 UpT V p d m _ e x e c _ q u e r y _ o p t i m i z e r _ i n f o "
11 > F ) " " F & UpT F d _ e x e c _ q u e r y _ o p t i m i z e r _ i n f o "
Wz > F " " F & UpT F d m _ e x e c _ q u e r y _ o p t i m i z e r _ i n f o "
F > F z " q "
UpT "
#1 > F Q < < 0 UpT 8 CREATE VIEW sys.dm_exec_query_optimizer_info AS
SELECT *
FROM OpenRowSet(TABLE OPTIMIZERINFO)
<
e > F 4 ) ! ) C 0 - UpT @ @ C c o u n t e r )
30* > F V ) a ) 6UpT c o u n t e r )
>? > F 5 ) ) I 0 - UpT I o c c u r re n c e )
, >
F W ) ) & 6UpT & o c c u r r e n c e )
7
_ > F 6 )
) ? 0 - UpT >> 5 ? v a l u e )
*G > F X ) ) 6UpT v a l u e )
C" >
F t " " UpT "
11 > F t " " UpT "
11 P F HP(xPhP 0
m
d0 L F 3 . F I N V O K E A L T F UpT > F t " " $ . UpT "
11 > F 4 ) ) _ n UpT )
30* > F 5 ) ) x c UpT o )
,f o > F 6 ) ) UpT )
*Gc _ q > F t " "
F UpT "
11" P F . 088 0 < 0 UpT 8 CREATE VIEW sys.dm_exec_query_optimizer_info A * l' ( I' L F 3 F " C R E A T E / A L T E R V I E W F F y > F t " " ^ 0 0 y V ^ d m _ q n _ s u b s c r i p t i o n s "
= > F ; " " 4 & y 4 d m _ q n _ s u b c r i p t i o n s "
Fx('
, > F ) " " 4 & y 4 d m _ q n _ s u b s c r i p t i o n s "
=bH > F z " "
pT y" "
Ӣ/b9AP L F 3 F F S p l i t P a g e 2 F + < -
s.
+ ery_op 2 F < 4
IM
2 F Q <
4
Q >
F < q c
C@c o
@ F < P F < Q >? 2
F <
7
> F < e0 } K8 create proc sys.sp_fulltext_catalog
@ftcat sysname, -- full-text catalog name
@action varchar(20), -- create | drop | | rebuild | ...
@path nvarchar(101) = null -- optional file path for create (max of 100 chars!!!)
as
declare @objname sysname,
@tabname nvarchar(517),
@schemaname nvarchar(517)
declare @execstring nvarchar (4000)
set nocount on
-- sp_fulltext_catalog willrun under read committed isolation level --
set transaction isolation level READ COMMITTED
-- CHECK PERMISSIONS (must be a dbowner) --
if (is_member('db_owner') = 0)
begin
raiserror(15247,-1,-1)
return 1
end
if (db_name() in ('master','tempdb','model'))
begin
raiserror(9966, -1, -1)
return 1
end
-- VALIDATE PARAMS --
if @action is null
OR @action not in ('create','drop','start_full','start_incremental','sto','rebuild')
OR @ftcat is null OR datalength(@ftcat) = 0 -- allow spaces in the name, but not a 0-length string
OR (@path is not null and @action <> 'create')
OR (len(@path) > 100)
begin
raiserror(15600,-1,-1,'sys.sp_fulltext_catalog')
return 1
end
-- DISALLOW USER TRANSACTION --
set implicit_transactions off
if @@trancount > 0
begin
raiserror(15002,-1,-1,'sys.sp_fulltext_catalog')
return 1
end
declar @ftcatid smallint
select @ftcatid = fulltext_catalog_id from sys.fulltext_catalogs where name = @ftcat
if @action not in ('create', 'drop') and @ftcatid is null
begin
declare @curdbname sysname
select @curdbname = db_name()
declare @curdbnamelen int
select @curdbnamelen = LEN(@curdbname)
raiserror(7641,-1,-1,@ftcat, @curdbnamelen, @curdbname)
return 1
end
if @action = 'create'
begin
-- CREATE FULLTEXT CATALOG --
select @execstring ='CREATE FULLTEXT CATALOG '
+ quotename( @ftcat, '[')
+ CASE
when @path is null then ''
else ' IN PATH '''+REPLACE(@path ,N'''',N'''''')+''''
END
EXEC (@execstring)
end
if @action = 'drop'
begin
-- build DROP FULLTEXT CATALOG --
select @execstring = 'DROP FULLTEXT CATALOG '
+ quotename( @ftcat, '[')
EXEC (@execstring)
end
if @action = 'start_full'
begin
-- FIND all the table and start full crawl --
declare ms_crs_ftind cursor static local for
select T.name, schema_name(T.schema_id)
from sys.fulltext_indexes as FT join sys.objects as T on(FT.object_id = T.object_id)
where FT.fulltext_catalog_id = @ftcatid
open ms_crs_ftind
fetch ms_crs_ftind into @tabname,@schemaname
while @@fetch_status >= 0
begin
select @execstring = 'ALTER FULLTEXT INDEX ON'
+ quotename(@schemaname,'[')+'.'+quotename(@tabname,'[') + ' START FULL POPULATION '
EXEC (@execstring)
fetch ms_crs_ftind into @tabname,@schemaname
end
deallocate ms_crs_ftind
end
if @action = 'start_incremental'
begin
-- FIND all the table and start full crawl --
declare ms_crs_ftind cursor static local for
select T.name, schema_name(T.schema_id)
from sys.fulltext_indexes as FTjoin sys.objects as T on(FT.object_id = T.object_id)
where FT.fulltext_catalog_id = @ftcatid
open ms_crs_ftind
fetch ms_crs_ftind into @tabname,@schemaname
while @@fetch_status >= 0
begin
select @execstring = 'ALTER FULLTEXT INDEX ON '
+ quotename(@schemaname,'[')+'.'+quotename(@tabname,'[') + ' START INCREMENTAL POPULATION '
EXEC (@execstring)
fetch ms_crs_ftind into @tabname,@schemaname
end
deallocate ms_crs_ftind
end
if @action = 'stop'
begin
-- FIND all the table and start full crawl --
declare ms_crs_ftind cursor static local for
select T.name, schema_name(T.schema_id)
from sys.fulltext_indexes as FT join sys.objects as T on(FT.object_id = T.object_id)
where FT.fulltext_catalog_id = @ftcatid
open ms_crs_ftind
fetch ms_crs_ftind into @tabname,@schemaname
while @@fetch_status >= 0
begin
select @execstring = 'ALTER FULLTEXT INDEX ON '
+ quotename(@schemaname,'[')+'.'+quotename(@tabname,'[') + ' STOP POPULATION '
EXEC (@execstring)
fetch ms_crs_ftind into @tabname,@schemaname
end
deallocate ms_crs_ftind
end
if @action = 'rebuild'
begin
-- REBUILD FULLTEXT CATALOG --
select @execstring = 'ALTER FULLTEXT CATALOG '
+ quotename( @ftcat, '[') +' REBUILD '
EXEC (@execstring)
end
return 0 -- sp_fulltext_catalog
< F < MG > F < Q > F Q <
> F + < < } 2 F < 2 F Q 2 F < 2 F + < P F > F < < 0 y 8 CREATE VIEW sys.dm_qn_subscriptions AS
SELECT *
FROM OpenRowSet(TABLE SYSNOTIFICATIONSUBS)
<
> F & ) ) 0 - y 88
9 i d )
eR > F H )
) 6y i d )
xQ > F ' ) ) K 0 - y 88
K d a t a b a s e _ i d )
jQ-v] > F H ) ) ( 6y ( d a t a b a s e _ i d )
\ > F ( ) ) ; 0 - y U U ; s i d )
FsQ > F J ) ) 6y s i d )
CG=D > F ) ) ) G 0 - y 88
G o b j e c t _ i d )
8qh $ > F J ) ) $ 6y $ o b j e c t _ i d )
{s > ! F * ) ) C 0 - y == C c r e a t e d )
Rt( > " F H ) ! ) 6y c r e a t e d )
r}% > # F + ) " ) C 0 - y 88
C t im e o u t )
@4p> > $ F M ) # ) 6y t i m e o u t )
s i > % F , ) $ ) A 0 - y 88
A s t a t u s )
K _ۘ > & F M ) % ) 6y s t a t u s )
od > ' F t " " y "
= > ( F t " ( " y "
= P F &H&%P%$($# #X"!(! ` P HXx 880 0 9<
ep Ks ( L F 3 F I N V O K E A L T F y > F t " ) " $ y "
= > F & ) & ) " y > )
eR ; > F ' ) ) i t y " )
jQ-v]> > F ( ) ) d _ y c )
FsQ" > F ) ) ) y " )
8qh $P > F * ) ) y g )
Rt( > F + ) ) y )
@4p>
> F , ) ) y )
K _ۘc >
F t " "
y "
= P F
08888 0
7
> F < <
= L F 3 F " C R E A T E / A L T E R V I E W F F
$ > F i * " " | 0 0
$ V | d m _ e x e c _ q u e r y _ t r a n s f o r m a t i o n _ s t a t s "
6*\] ; > F * " " R
$ R d m _ e x e c _ q u e r y _ t r a n s f o r m a t i o n _ s t a t s "
Tza+) > F " " R &
$ R d m _ e x e c _ q u e r y _ t r a n s f o r m a t i o n _ s t a t s "
5=LQ) > F z " "
$ "
8 > F < < 0
$ 8 REATE VIEW sys.dm_exec_query_transformation_stats AS
SELECT *
FROM OpenRowSet(TABLE SYSRULESTATS)
<
y > F ) ) = 0 -
$ @ 4 @ = n a m e )
YQ > F & h ) q ) 6
$ n a m e )
1& 0 > F ) ) O 0 -
$ O p r o m i s e _ t o t a l . )
t >
F & i ) ) , 6
$ , p r o m i s e _ t o t a l )
r{ nvar > F )
) K !!0 -
$ >> 5 K p r o m i s e _ a v g ) )
@name n > F & i ) ) ( ou6
$ ( p r o m i s e _ a v g )
5Лte >
F ) ) E ED0 -
$ E p r o m i s e d r(' )
x#jeg > F & k )
) " f 6
$ " p r o m i s e d mo )
y r > F ) ) U AR0 -
$ U b u i l t _ s u b s t i t u t e l', )
H`to > F & h ) ) 2 al6
$ 2 b u i l t _ s u b s t i t u t e
)
l`t null > F ) ) G 0 -
$ G s u c c e e d e d
)
afrkAL > F & m ) ) $ ra6
$ $ s u c c e e d e d )
gxqsp_ful > F i * " " sel
$ "
6*\]g_id f > F i * " " ', dro
$ "
6*\]begin
P F melen @ @
H P (p 0 )
raiserror(7641,-1,-1,@ftcat, @curdbnamelen, @curdbname)
return 1
end
if @action = 'create'
begin
-- CREATE FULLTEXT CATALOG --
select @execs C& " L F 3 2 F I N V O K E A L T F
$ > F i * " " $ 2
$ "
6*\] > F ) ) a i
$ s )
YQ ; > F ) )
$ c )
t s f o > F ) )
$ )
@ > F ) ) t
$
)
x#j > F ) )
$ > )
H` > F ) ) E VEW
$ er )
afrk AS
> F i * " "
$ "
6*\] P F 2 e 8888 0 > F & h ) q ) 6
$ n a m e )
1& 0 > F ) ) O 0 -
$ ; n: < '- L F 3 F " C R E A T E / A L T E R V I E W F F U} > F t " " p 0 0 U} V p d m _ e x e c _ b a c k g r o u n d _ j o b _ q u e u e "
20 0 > F ) " " F & U} F d _ e x e c _ b a c k g r o u n d _ j o b _ q u e u e o "
r6=C > F " " F & U} F d m _ e x e c _ b a c k g r o u n d _ j o b _ q u e u e "
B[V > F z " "
U} "
~" > F < a < H0 U} 8 CREATE VIEW sys.dm_exec_background_job_queue AS
SELECT *
FROM OpenRowSet(TABLE DM_EXEC_BACKGROUND_JOB_QUEUE)
<
ue >
c ' ) >
c ' ) 6 ) ; > F c ) ) K 0 - U} == K t i m e _ q u e u e d )
\G > F u ) ' ) ( 6U} ( t i m e _ q u e u e d )
ȕ6 > F c ) ) A 0 - U} 88
A j o b _ i d )
iT >
F u ) ) 6U} j o b _ i d r )
F L F 3 F F S p l i t P a g e 2 F ) ]
o 2 F c )
$
c 2 F ) !
)
#jeg 6 F ) J e > F )
c , r > F ) c ,
@
( 6 F
l ) 7 e
@ F ) 6 c J e P F ( ) c - 2 F ( ) &
( > F ( ) d G C ? G E A E E ? G E ; K ? A I G G U I C C M G Q ? A ? A K K K K K K C Q G C I S = A A E M O I I O E M I S K G S ? ? U c I E G G I E [ [ G M W a O Y S q { u K K S _ K U K S E K O I ] Q U C A 0 - z G @ r e s a m p l e 0 - X C k e y w o r d 0 - X 88
? c o l i d 0 - X 88
G u n u s e d P i d 0 - X E d o c i d m a x dbn0 - X 88
A d u p s e q be0 - X E d o c i d m i n C& - X E d o c c o u n t 0 - X ? d o c i d 0 - X 88
G d o c l e n g t h 0 - X
88
E o c c c o u n t = 0 - X 88
; o c c -0 - X 88
K i n t e r n a l P i d t0 - X 88
? @ d b i d
0 - X 88
A @ o b j i d ta0 - X 88
I @ c o m p l e v e l oca0 - 7 G @ r o l e n a m e 0 - v% 88
G o b j e c t _ i d =0 - v% 44 U p r o c e d u r e _ n u m b e r rs_0 - v% @ I d e f i n i t i o n e @0 - ,+ @ C @ c o o k i e 0 - C k e y w o r d ,0 - @ @ M d i s p l a y _ t e r m C (0 - 88
G c o l u m n _ i d e0 - Q d o c u m e n t _ c o u n t art0 - 88
? @ d b i d r0 - 88
A @ o b j i d fo0 - VJ ? @ n a m e 0 - VJ bb P A @ v a l u e obj0 - VJ K @ l e v e l 0 t y p e
0 - VJ K @ l e v e l 0 n a m e n0 - VJ K @ l e v e l 1 t y p e e0 - VJ K @ l e v e l 1 n a m e n0 - VJ K @ l e v e l 2 t y p e 0 - VJ K @ l e v e l 2 n a m e ,0 - 9b C @ d b n a m e d0 - 9b 00 Q @ n e w _ c m p t l e v e l ull0 - d G @ a c c t n a m e 0 - d
C @ o p t i o n .0 - d
I @ p r i v i l e g e d)
0 - s x x S p e r m i s s i o n _ n a m e 0 - s = t y p e ile0 - s x A @ l e v e l ng 0 - s A @ p e r m s nam0 - $ E @ d e v t y p e EX0 - $ M @ l o g i c a l n a m e
0 - $ O @ p h y s i c a l n a m e i0 - $ 44 I @ c n t r l t y p e xec0 - $ ( I @ d e v s t a t u s +'0 - $$ O a g _ r e p l i c a _ i d l0 - $$ E a g _ d b _ i d 0 - M r e c o v e r y _ l s n 0 - 00 I s y n c _ s t a t e 0 -
hh S @ c r e a t e N e w S t a t e 0 -
88
K @ n e w s t a t e i d 0 -
88
G @ pa r e n t i d 0 -
88
S @ p h r a s e I d O r N u l l 0 -
? @ t e r m 0 -
88
? @ l c i d 0 -
hh U @ n e w S t a t e C r e a t e d 0 -
hh c @ d u p l i c a t e T h e s a u r u s R u l e O0 - Y
I @ f u n c t n a m e 0 - Y E @ d l l n a m e 0 - _ G @ r o l e n a m e 0 - _ G @ p a s s w o r d 0 - 7 $$ I r e p l i c a _ i d 0 - 7 $$ E g r o u p _ i d d a0 - 7 88
[ r e p l i c a _ m e t a d a t a _ i d 0 - 7 4 [ r e p l i c a _ s e r ve r _ n a m e 0 - 7 U U G o w n e r _ s i d 0 - 7 4 M e n d p o i n t _ u r l F0 - 7 00 W a v a i l a b i l i t y _ m o d e 0 - 7 x x a a v a i l a b i l i t y _ m o d e _ d e s c 0 - 7 00 O f a i l o v e r _ m o d e i0 - 7
x x Y f a i l o v e r _ m o de _ d e s c 0 - 7 88
S s e s s i o n _ t i m e o u t 0 - 7 00 q p r i m a r y _ r o l e _ a l l o w _ c o n n e c t i o n s c r0 - 7
x 4 x { p r i m a r y _ r o l e _ a l l o w _ c o n n e c t i o n s _ d e s c 0 - 7 00 u s e c o n d a r y _ r o l e _ a l l o w _ c o n n e c t i o n s - 0 - 7 x 4 x s e c o n d a r y _ r o l e _ a l l o w _ c o n n e c t i o n s _ d e s c 0 - 7 == K c r e a t e _ d a t e 0 - 7 == K m o d i f y _ d a t e 0 - 7 88
S b a c k u p _ p r i o r i t y 0 - 7 4 _ r e a d _ o n l y _ r o u t i n g _ u r l 0 - Z 88
K d a t a b a s e _ i d 0 - Z 88
U e n c r y p t i o n _ s t a t e
0 - Z == K c r e a t e _ d a t e 0 - Z == S r e g e n e r a t e _ d a t e 0 - Z == K m o d i f y _ d a t e #0 - Z == E s e t _ d a t e 0 - Z == K o p e n e d _ d a t e 0 - Z 4 O k e y _ a l g or i t h m 0 - Z 88
I k e y _ l e n g t h 0 - Z
] e n c r y p t o r _ t h u m b p r i n t 0 - Z 4 Q e n c r y p t o r _ t y p e 0 - Z ;; U p e r c e n t _ c o m p l e t e 0 - ә C @ a c t i o n 0 - ә bb P A @ v a l u e < F c ) ( b > F c ) ( > F ) c ( > F o ) ) z ( 2 F ( ) 2 F ) 2 ! F c ) 2 " F ) P F > F c ) " ) K 0 - U} 88
K d a t a b a s e _ i d )
EX > % F u ) ) ( 6U} ( d a t a b a s e _ i d )
3_P< > & F c ) % ) I 0 - U}̀ 88
I o b j e c t _ i d 1 )
}5- > ' F w ) & ) & 6U} & o b j e c t _ i d 1 )
H^ > ( F c ) ' ) I 0 - U} 88
I o b j e c t _ i d 2 )
^}! > ) F x ) ( ) & 6U} & o b j e c t _ d 2 )
v > * F c ) ) ) I 0 - U} 88
I o b j e c t _ i d 3 )
dp > + F y ) * ) & 6U} & o b j e c t _ i d 3 )
i > , F c
) + ) I 0 - U} 88
I o b j e c t _ i d 4 )
> - F z ) , ) & 6U} & o b j e c t _ i d 4 )
ƫh > . F c ) - ) I 0 - U} 88
I e r r o r _ c o d e )
`w > / F v ) . ) & 6U} & e r r o r _ c o d e )
Q & > 0 F c ) / ) M 0 - U} 44 M r e q u e s t _ t y p e )
u{ > 1 F | ) 0 ) * 6U} * r e q u e s t _ t y p e )
> 2 F c
) 1 ) K 0 - U}
44 K r e t r y _ c o u n t )
[A > 3 F } ) 2 ) ( U}
( r e t r y _ c o u n t )
MN. > 4 F c ) 3 ) K 0 - U} 44 K i n _ p r o g r e s s )
0 > 5 F w ) 4 ) ( 6U} ( i n _ p r o g r e s s )
i > 6 F c ) 5 ) I 0 - U} 44 I s e s s i on _ i d )
Ⱦ > 7 F ) 6 ) & 6U} & s e s s i o n _ i d )
{ > 8 F t " " U} "
20 0 > 9 F t " 9 " U} "
20 0 P F 9(98(876@655x43@322X10 0/.`.-(-x, ,++x+@+**0*)
p
8
X x0xP`hP 0 x 6 \i o 0Ko
m *
< g$ L F 3 F I N V O K E A L T F U} > F t " : " $ U} "
20 0 > F c ) 7 ) q e U} )
\G > F c ) ) x c U} o )
iTu e o > F c ) ) U} )
EXc _ b > F c ) ) F U} )
}5- > F c ) ) U} < )
^}! U} > F c ) ) ECT*
U} et )
dpUND_JO > F c
) ) U} )
\
>
F c )
) U} > )
`w > F c ) ) U} e )
u{) > F c
) ) U}
)
[Au e d >
F c )
) U} - )
0 > F c ) ) F U} )
Ⱦ > F t " "
F U} "
20 0 P F 8888888 0 2 F c )
$
c 2 F ) !
)
#jeg 6 F ) J e > F )
c , r > F ) c ,
@
( 6 F
l ) 7 e
@ " $
5 L F 3 F " C R E A T E / A L T E R V I E W F F >
t ( " 6 " > F t P " " | 0 0 V | d m _ e x e c _ b a c k g r o u n d _ j o b _ q e u e _ s t a t s "
FI
i > F * " " R & R d m _ e x e c _ b a c k g r o u n d _ j o b _ q u e u e _ s t a t s "
f? > F " " R 5& R d m _ e x e c _ b a c k g r o u n d _ j o b _ q u e u e _ s t a t s "
71]b< > F z Q " "
"
FƏ
U} > F q < ' <
0 8 CREATE VIEW sys.dm_exec_background_job_queue_stats AS
SELECT *
FROM OpenRowSet(TABLE DM_EXEC_BACKGROUND_JOB_QUEUE_STATS)
<
AzF} > F 7 : ) O ) O 0 - 88
O q u e u e _ m a x _ l e n )
{ >
F % ) I ) 6 , q u e u e _ m a x _ l e n )
7M,[ > F 7 ; )
) Q 0 - 88
Q e n q u e u e d _ c o u n t ) )
Uj¢ > F % ) ) . 6 . e n q u e u e d _ c o u n t )
r ߅ >
F 7 < ) ) O 0 - 88
O s t a r t e d _ c o u n t )
>' > F % )
) , 6 , s t a r t e d _ c o u n t )
d > F 7 = ) ) K 0 - 88
K e n d e d _ c o u n t )
tK > F % ) ) (
6 ( e n d e d _ c o u n t )
;͖ > F 7 > ) ) W 0 - 88
W f a i l e d _ l o c k _ c o u n t )
8b > F % ) ) 4 6 4 f a i l e d _ l o c k _ c o u n t )
cGCA E E > F 7 ? ) ) Y A 0 - 88
Y f a i l e d _ o t h e r _ c o u n t E )
حLljk- z > F % ) ) 6 6 6 f a i l e d _ o t h e r _ c o u n t r )
6E > F 7 @ ) ) [ 0 - 88
[ f a i l e d _ g i v e u p _ c o u n t )
!'gbn0 - > F % ) ) 8 6 8 f a i l e d _ g i v e u p _ c o u n t )
_= > F 7 A ) ) g 0 - 88
g e n q u e u e _ f a i l e d _ f u l l _ c o u n t o )
"~ > F % ) ) D 6 D e n q u e u e _ f a i l e d _ f u l l _ c o u n t )
*t//x > F 7 B ) ) q 0 - 88
q e nq u e u e _ f a i l e d _ d u p l i c a t e _ c o u n t
)
QIV I > F % ) ) N 6 N e n q u e u e _ f a i l e d _ d u p l i c a t e _ c o u n t b )
P%r > F 7 C ) ) Q b0 -
88
Q e l a p s e d _ a v g _ m s e @ )
gf1 > F % ) ) 6
. e l a p s e d _ a v g _ m s )
x > F 7 D ) ) Q 0 - 88
Q e l a p s e d _ m a x _ m s )
H w= e n t > F % ) ) . d6 . e l a p s e d _ m a x _ m s )
& d > F t P " " bb "
FI A > F t P " " e l 0 t "
FI P F PXx
`
HP0P 0 K @ l e v e l 1 n a m e n0 - VJ K @ l e v e l 2 t y p e 0 - VJ K @ l e v e l 2 n a m e ,0 - 9b . ,u L F 3 7 F I N V O K E A L T F > F t P " ! " $ 7 "
FI > F 7 : ) ) 0 )
{ > F 7 ; ) ) e s " )
Uj¢> > F 7 < ) ) d _ c )
>'_ q u > F 7 = ) ) " )
tK > F 7 > ) ) " < )
8b > F 7 ? ) ) Ə
)
حLljk > F 7 @ ) ) ys.m_e _j )
!'gLECT * >
F 7 A )
)
A )
"~ > F 7 B ) ) O a )
QIV
> F 7 C ) )
q )
gf1n >
F 7 D )
) - )
H w= > F t P " "
> "
FI P F 7 ) 0888888 0 F 7 < ) ) O 0 - 88
0 0 j\ L F 3 & F " C R E A T E / A L T E R V I E W F F g > F i "
" f 0 0 g V f d m _ d b _ i n d e x _ u s a g e _ s t a t s "
I#^H > F ( " " < & g < d m _ d b i n d e x _ u s a g e _ s t a t s "
(P> > F " " < d & g < d m _ d b _ i n d e x _ u s a g e _ s t a t s "
f$q > F z " "
g "
L > F < & < 0 g 8 CREATE VIEW sys.dm_db_index_usage_stats AS
SELECT database_id, object_d, index_id,
user_seeks, user_scans, user_lookups, user_updates,
last_user_seek, last_user_scan, last_user_lookup, last_user_update,
system_seeks, system_scans, system_lookups, system_updates,
last_system_seek, last_system_scan, last_system_lookup, last_system_update
FROM OpenRowSet(TABLE LOGINDEXSTATS)
WHERE status = 0
<
\ǒԻ > F 6 ? )
) K
0 - g 44 K d a t a b a s e _ id )
ƌq > F e ) U ) ( 6g ( d a t a b a s e _ i d )
~;S > F 6 @ ) ) G 0 - g 88
G o b j e c t _ i d )
Z0 >
F f ) ) $ 6g $ o b j e c t _ i d )
W.Ҝ > F 6 A )
) E e0 - g 88
E i n d e x _ i d )
䃔 > F f ) ) " 6g " i n d e x _ i d )
-Wf >
F 6 B ) ) I 0 - g I u s e r _ s e e k s F )
~ > F h )
) & ) g & u s e r _ s e e k s )
L: > F 6 C ) ) I 0 - g I u s e r _ s c a n s )
bߊ\r > F h ) ) & k 6g & u s e r _ s c a n s E )
`' > F 6 D ) ) M 0 - g M u s e r _ lo o k u p s )
> F h ) ) * 6g * u s e r _ l o o k u p s n )
Ƈ8mHE > F 6 E ) ) M 0 - g M u s e r _ u p d a t e s p _ )
{} > F k ) ) * 6g * u s e r _ u p d a t e s e )
W1FIUu n t > F 6 F ) ) Q 0 - g == Q l a s t _ u s e r _ s e e k q u )
A$ f u l > F g ) ) . 6g . l a s t _ u s e r _ s e e k )
Zajce > F 6 G ) ) Q 0 - g == Q l a s t _ u s e r _ s c a n )
( > F g ) ) . 6g . l a s t _ u s e r _ s c a n )
P > F 6 H ) ) U _ 0 - g
== U l a s t _ u s e r _ l o o k u p C )
` > F g ) ) 2 l6g
2 l a s t _ u s e r _ l o o k u p )
26P% > F 6 I ) ) U a 0 - g == U l a s t _ u s e r _ u p d a t e )
DZ > F j ) ) 2 e6g 2 l a s t _ u s e r _ u p d a t e > )
8 > F 6 J ) ) M d 0 - g M s y s t e m _ s e e k s )
* > F l ) ) * 6g * s y s t e m _ s e e k s )
VB-FK t > F 6 K ) ) M 0 - g
M s y s t e m _ s c a n s
)
Ӯ > F l ) ) * 6g
* s y s t e m _ s c a n s v )
Vn7 > ! F 6 L ) ) Q 0 - g Q s y s t e m _ l o o k u p s )
3 ] Q > " F l ) ! ) . 6g . s y s t e m _ l o o k u p s )
jB; > # F 6 M ) " ) Q 0 - g Q s y s t e m _ u p d a t e s S )
֨-Q n a m > $ F o ) # ) . - 6g s y s t e m _ u p d a t e s A )
4gf& > % F 6 N ) $ ) U 0 - g == U l a s t _ s y s t e m _ s e e k )
vZ5[8 M > & F g ) % ) 2 6g 2 l a s t _ s y s t e m _ s e e k 44 )
{Ǯ > ' F 6 O ) & ) U 0 - g == U l a s t _ s y s t e m _ s c a n O )
2:14 i > ( F g ) ' ) 2 d6g 2 l a s t _ s y s t e m _ s c a n )
OAo l s n > ) F 6 P ) ( ) Y a0 - g == Y l a s t _ s y s t e m _ l o o k u p e )
-z > * F g ) ) ) 6 6g 6 l a s t _ s y t e m _ l o o k u p
)
{1 > + F 6 Q ) * ) Y 0 - g == Y l a s t _ s y s t e m _ u p d a t e )
+Bt
> , F j ) + ) 6 d6g 6 l a s t _ s y s t e m _ u p d a t e c )
a{{ h > - F i " " @ fu ng "
I#^H > . F i " . " g "
I#^H n a m P F & x 0 @8`h(@@
h
( x
@
P pP@ 0 E g r o u p _ i d d a0 - 7 88
[ r e p l i c a _ m e t a d a t a _ i d 0 - 7 4 [ r e p l s. 6 i_ L L F 3 * F I N V O K E A L T F g > F i " / " $ g "
I#^H > F 6 ? ) , ) g ^H )
ƌ > F 6 @ ) ) d x g s )
Z0
> F 6 A ) ) d g _ )
䃔 a g e > F 6 B ) ) g )
~ > F 6 C ) ) g )
bߊ\r8 > F 6 D ) ) nde_idg ks )
kups, > F 6 E ) ) _upateg ek )
{}m_look >
F 6 F )
) up,lasg e
)
A$LE LOG > F 6 G ) ) g )
(
> F 6 H ) ) ) g
q )
` >
F 6 I )
) s _ g )
DZ > F 6 J ) )
g )
* i d > F 6 K ) ) g
)
Ӯ c t _ > F 6 L ) ) ) g )
3 ]
> F 6 M ) ) g )
֨-Q) > F 6 N ) ) > g )
vZ5[8 > F 6 O ) ) u se rg )
2:14 > F 6 P ) ) g _ )
-z
> F 6 Q ) ) - g )
+Bt > F i " "
g "
I#^H P F * 0
8
8 88888888 0 M 0 - g M u s e & 1[ L F 3 Q 0 F " C R E A T E / A L T E R V I E W F F > F N " &! " v 0 0 V Q Q v d m _ d b _ m i s s i n g _ i n d e x _ g r o u p _ s t a t s "
5j5ƌ > F ) " " L & L d m _ d b _ m i s s i n g _ i n d e x _ g r o u p _ s t a t s "
Csג > F " " L & L d m _ d b _ m i s s i n g _ i n d e x _ g r o u p _ s t a t s "
/I
g > F z " "
C "
Z'W > F < < . 0 .8 CREATE VIEW sys.dm_db_mising_index_group_stats AS
SELECT IdxS.index_id as group_handle,
unique_compiles,
-- stats for user queries
user_seeks, user_scans, last_user_seek, last_user_scan,
case
when (user_seeks + user_scans) > 0
then total_user_cost / (user_seeks + user_scans)
else 0
end as avg_total_user_cost,
case
when (user_seeks + user_scans) > 0
then ceiling(total_user_impact / (user_seeks + user_scans) * 10000.0 - 0.5) / 100.0
else 0
end as avg_user_impact,
-- statsfor system queries
system_seeks, system_scans, last_system_seek, last_system_scan,
case
when (system_seeks + system_scans) > 0
then total_system_cost / (system_seeks + system_scans)
else 0
end as avg_total_system_cost,
case
when (system_seeks + system_scans) > 0
then ceiling(total_system_impact / (system_seeks + system_scans) * 10000.0 - 0.5) / 100.0
else 0
end as avg_system_impact
FROM OpenRowset(TABLE LOGINDEXSTATS) IdxS
WHERE IdxS.status <> 0
<
Vս > F ) &!
) M M 0 - 88
M g r o u p _ h a n d l e )
& > F ) &! ) * 6 * g r o u p _ h a n d l e )
͉u > F ) ) S 0 - S u n i q u e _ c o m p i l e s )
< >
F ) ) 0 6 0 u n i q u e _ c o m p i l e s )
TY֑ > F
)
) I 0 - I u s e r _ s e e k s )
W > F
) ) & 6 & u s e r _ s e e k s 0 )
<T >
F ) ) I ) 0 - I u s e r _ s c a n s )
+`k > F
)
) & 6 & u s e r _ s c a n s )
& > F ) ) Q _0 - == Q l a s t _ u s e r _ s e e k )
ұ > F ) ) 6 . l a s t _ u s e r _ s e e k )
u+== > F
) ) Q 0 - == Q l a s t _ u s e r _ s c a n )
2%J
> F ) ) . 6 . l a s t _ u s e r _ s c a n )
5== > F ) ) [ 0 - >> 5 [ a v g _ t o t a l _ u s e r _ c o s t )
Nl a s > F ) ) 8 6 8 a v g _ t o t a l _ u s e r _ c o s t )
) > F ) ) S
0 - >> 5 S a v g _ u s e r _ i m p a c t )
BK_ u s > F ) ) 0 6 a v g _ u s e r _ i m p a c t )
7 > F ) ) M ) 0 - M s y s t e m _ s e e k s )
v > F
) ) * 6 * s y s t e m _ s e e k s ) )
6 !- g > F ) ) M 0 -
M s y s t e m_ s c a n s )
[P > F
) ) * 6
* s y s t e m _ s c a n s ) )
63 - g > F ) ) U
0 - == U l a s t _ s y s t e m _ s e e k )
eW\ > F ) ) 2 6 2 l a s t _ s y s t e m _ s e e k )
E > F ) ) U 0 - == U l a s t _ s y s t e m _ s c a n )
R;)s > F ) ) 2 6 2 l a s t _ s y s t e m _ s c a n - )
> F ) ) _ 0 -
>> 5 _ a v g _ t o t a l _ s y s t e m _ c o s t )
c9
%a > F ) ) < 6
< a v g _ t o t a l _ s y s t e m _ c o s t )
iy U l a > ! F ) ) W 0 - >> 5 W a v g _ s y s t e m _ i m p a c t )
> " F ) ! ) 4 6 4 a v g _ s y s t e m _ i m p a c t )
\" U l a > # F N " " "
5j5 > $ F N " $ " OA l "
5j5 P P F Q 0 pXp(x8XP
H
P ` 0 * F g ) ) ) 6 6g 6 '$ 0 . s .
' ө
L F 3 _ 4 F I N V O K E A L T ' F > ' F N " % " $ Q _ "
5j5 > ' F ) " ) u _ )
&> > ' F ) ' ) d _ i )
<o u p > ' F
) ' ) )
W L d > ' F ) ' ) /
)
+`k > ' F ) ' ) )
ұ < > ' F
) ' ) _inex_
)
2%J
d as g > ' F ) ' ) , uer_ er )
N
ca > '
F ) '
) sees + )
BK_total > ' F ) ' ) totl_u us )
v * 100 > ' F ) ' ) sysem
te )
[P last_ > '
F ) '
) ) >0
_s )
eW\eeks + > ' F ) ' ) (sste em )
R;)eiling > ' F ) ' )
el
s )
c9
%FROM O > ' F ) ' )
V )
> ' F N " ' "
M "
5j5 ) P ' F _ ' 4 88888888 0 l e )
͉u > F ) ) S 0 - S u n i q u e _ c o m p i l e s ) 6 d4 6
, L F 3 : F " C R E A T E / A L T E R V I E W F , F v L F 3 ; F F
S p l i t P a g e 2 , F M " !
M _ 2 , F t "
t 2 , F h "
h i > , F " c o
) @
k @ , F " P , F k " t 0 h 2 , F k " , 5
k > ,
F k " ,
+ T P h V t \ R b n ^ ^ ` T v T N T t X \ P R n R j P L ^ Z L X b f Z b \ \ X | 0 0 9bЀ P * r T s p _ d b c m p t l e v e l 0 0 d P 4 P x p _ l o g i n i n f o 0 0 s IF ' ? h f n _ t r a n s l a t e _ p e r m i s s i o n s 0 0 $ P . r V s p _ a d d u m p d e v i c e 0 0 V (q (q d m _ h a d r _ i n t e r n a l _ w s f c _ a g _ d b _ r e p l i c a s 0 0
P t s p _ f u l l t e x t _ t h e s a u r u s _ a d d _ t e r m 0 0 Y P _ \ s p _ a d d e x t e n d e d p r o c 0 0 _ P B R s p _ a d d a p p r o l e 0 0 7 V
s +s b a v a i l a b i l i t y _ r e p l i c a s 0 0 Z V ί n d m _ d a t a b a s e _ e n c r y p t i o n _ k e y s 0 0 ә P ^ s p _ f u l l t e x t _ s e r v i c e 0 0 V r %r ^ a v a i l a b i l i t y _ g r o u p s 0 0 *т X j ` s p _ r e l e a s e s c h e m a l o c k 0 0 P T s p _ r e f r e s h v i e w 0 0 P G v s p _ f u l l t e x t _ l o a d _ t h e s a u r u s _ f i l e 0 0 cG IF > > T f n _ f l l t e x t _ i 4 0 0 J| P Z N s p _ b i n d r u l e u 0 0 IF T f n _ f u l l t e x t _ i 2 0 0 kX P H0 H0 t s p _ S e t S D S P u b l i c I n t e r f a c e O b j e c t 0 0 V H R X d m _ a u d i t _ a c t i o n s 0 0 P \ s p _ a p p r o l e p a s s w o r d 0 0 # P ʦ P s p _ v a l i d l a n g 0 0 %H P r R s p _ d r o p d e v i c e > 0 0 > P n s p _ c h e c k _ r e m o v a b l e _ s y s u s e r s 0 0 ' P ߳ u R s p _ h e l p r o t e c t 0 0 J P & & j s p _ S e t I n t e r n a l T a b l e A c c e s s
0 0
V B B P i n d e x _ c o u n s 0 0 L% V \ z L u s e r _ t o k e n 0 0 =H X ^ s p _ r e c o m p i l e _ m o d u l e 0 0 ` IF а Z f n _ g e t _ a u d i t _ f i l e > 0 0 a` P P L s p _ a d d u s e r 0 0 u P X s p _ d b s c r i p t l e v e l 0 0 G V \ z b d m _ f t s _ m e m o r _ b u f f e r s [0 0 k V a f d m _ f t s _ i n d e x _ p o p u l a t i o n 0 0 V Z s e c u r a b l e _ c l a s s e s t 0 0 1 V G f b d m _ o s _ c h i l d _ i n s t a n c e s - 0 0 Ǥ P s \ s p _ c h e c k _ r e m o v a b l e 0 0 s̆ P \ s p _ r e s i g n _ d a t a b a s e 0 0 V ޠ ( s y s t e m _ c o m p o n e n t s _ s u r f a c e _ a r e a _ c o n f i g u r a t i o n 0 0 B P ] X s p _ a d d r o l e m e m b e r 0 0 V 7 | d m _ e x e c _ b a c k g r o u n d _ j o b _ q u e u e _ s t a t s < , F t ( " , k ) > , F t " , h k > ,
F h " , t k
> , F M " , " _ 9bk 2 , F k " , 2 , F h " , == 2 , F t " ,
e 2 , F M " , P , F , ; _ s y > , F k " " l 0 0 v V l d m _ d b _ m i s s i n g _ i n d e x _ g r o u p s "
oTrlH n > , F * " " B & v B d m _ d b _ m i s s i n g _ i n d e x _ g r o u p s s "
܊K
> , F " " B & v B d m _ d b _ m i s s i n g _ i n d e x _ g r o u p s _ "
ǬM' m _ c > F z ? " "
v) "
YFB
> , F < < + < y0 v 8 CREATE VIEW sys.dm_db_missing_index_groups AS
SELECT *
FROM OpenRowset(TABLE MISSING_IDX_GROUPS)
v <
B 9 p > , F # ) ! ) Y 0 - v 88
Y i n d e x _ g r o u p _ h a n d l e ) )
Rh> > , F $ T ) 3 ) 6 6v 6 i n d e x _ g r o u p _ h a n d l e )
3PSV > , F $ ) , ) M 5j0 - v 88
M i n d e x _ h a n d l e )
dݬp L F 3 < F F S p l i t P a g e ) 2 , F ) '
l o o 2 , F $ ) ,
$ 2 , F % )
% 6 , F ) f ) > , ! F ) , c 4 > , " F ) , " c 4
{@{ h
0 - 6 , # F
) & f @ f @ , $ F ) 6 c f P , % F 0 ) $ % 2 , ' F 0 ) , '
@
0 ` > , ( F 0 ) , ( W " * " * 0 $ & " $ ( & * : , 6 $ > 4 & , < @ & $ : $ ( 6 ( 0 : 8 < : & L $ $ J N F J H < B " $ ( , & . * $ & < 0 H ( < @ . @ 0 H > V ( & 6 " * 6%H " @ d e l f i l r6%H * @ l o g i c a l n a m e U6> " @ a u t o f i x i6' * @ g r a n t o r n a m e 6' @ n a m e 6' 0 @ p e r m i s s i o n a r e a 6' $ @ u s e r n a m e 6J @ o b j e c t 6J @ s c h e m a 6
& d a t a _ p a g e s _6
" i n d e x _ i d 6
$ o b j e c t _ i d 6
r o w s 6
( t o t a l _ p a g e s 6
& u s e d _ a g e s c6L% n a m e 6L% * p r i n c i p a l _ i d _6L% s i d 6L% t y p e 6L% u s a g e 6` : @ a u d i t _ r e c o r d _ o f f s e t 6` , @ f i l e _ p a t t e r n 6` 6 @ i n i t i a l _ f i l e _ n a m e o6` $ a c t i o n _ i d 6` > a d d i t i o n a l _ i n f o r m a t i o n a6` 4 a u d i t _ f i l e _ o f f s e t 6`
& c l a s s _ t y p e6` , d a t a b a s e _ n a m e 6` < d a t a b a s e _ p r i n c i p a l _ i d 6` @ d a t a b a s e _ p r i n c i p a l _ n a m e 6` & e v e n t _ t i m e i6` $ f i l e _ n a m e 6` : i s _ c o l u m n _ p e r m i s s i o n t6` $ o b j e c t _ i d 6` ( o b j e c t _ n a m e 6` 6 p e r m i s s i o n _ b i t m a s k 6` ( s c h e m a _ n a m e 6` 0 s e q u e n c _ n u m b e r 6` : s e r v e r _ i n s t a n c e _ n a m e ==6` 8 s e r v e r _ p r i n c i p a l _ i d 6` < s e r v e r _ p r i n c i p a l _ n a m e 6` : s e r v e r _ p r i n c i p a l _ s i d 6` & s e s s i o n _ i d t6` L s e s s i o n _ s e r v e r _ p r i n c i p a l _ n a m e 6` $ s t a t e m e n t 6` $ s u c c e e d e d 6` J t a r g e t _ d a t a b a s e _ p r i n c i p a l _ i i6` N t a r g e t _ d a t a b a s e _ p r i n c i p a l _ n a m e h6`
F t a r g e t _ s e r v e r _ p r i n c i p a l _ i d o6` J t a r g e t _ s e r v e r _ p r i n c i p a l _ n a m e 6` H t a r g e t _ s e r v e r _ p r i n c i p a l _ s i d 6` < u s e r _ d e f i n e d _ e v e n t _ i d 6` B u s e r _ d e f i n e d _ i n f o r m a t i o n 6a` " @ g r p n a m e 6a` $ @ l o g i n a m e 6a` ( @ n a m e _ i n _ d b 6u @ d b n a m e 6u , @ s c r i p t _ e n t r y 6u @ v a l u e > 6G & b y t e s _ u s e d 6G i s _ f r e e 6G . m e m o r y _ a d d r e s s 6G n a m e 6G * p e r c e n t _ u s e d 6G p o o l _ i d 6G $ r o w _ c o u n t 6 k & c a t a l o g _ i d 6 k < c o m p l e t e d _ r a n g e _ c o u n t 6 k
0 c o m p l e t i o n _ t y p e 6 k H c o m p l e t i o n _ t y p e _ d e s c r i p t i o n 6 k ( d a t a b a s e _ i d 6 k < i n c r e m e n t a l _ t i m e s t a m p 6 k @ i s _ c l u s t e r e d _ i n d e x _ s c a n 6 k . m e m o r y _ a d d r e s s 6 k
@ o u t s t a n d i n g _ b a t c h _ c o u n t 6 k 0 p o p u l a t i o n _ t y p e 6 k H p o p u l a t i o n _ t y p e _ d e s c r i p t i o n 6 k > q u e u e d _ p o p u l a t i o n _ t y p e t6 k V q u e u e d _ p o p u l a t i o n _ t y p e _ d e s c r i p t i o n 6 k ( r a n g e _ c o u n t 6 k & s t a r t _ t i m e
6 k s t a t u s 6 k 6 s t a t u s _ d e s c r i p t i o n 6 k " t a b l e _ i d 6 k * w o r k e r _ c o u n t < , ) F $ U ) , 0 U ( > , * F $ ) , * % 0 v > , + F % ) , $ - 0 88 > , , F ) , ) $ 6%H 0 $ @ d e l f i l e 2 , - F 0 ) , ) 2 , . F % ) , , 2 , / F $ ) , + 2 , 0 F ) , - P , F , < > , F $ U ) , 0 ) * j 6v * i n d e x _ h a n d l e > )
6 > , 3 F k " , " v "
oTrlH > , 4 F k " , 4 " v "
oTrlHe r r P , F , : / 3(32 211X1 10x0 0// P 8 X XPhPHHX` H 0 )
u{ > 1 F | ) 0 ) * 6U} * r e q u e s t _ t y p e )
> 2 F c
) 1 ) K 0 - U}
44 K r e t r y _ c o u n t )
[A > 3 F } ) 2 deepe,, ytu 6 G Py8 L G 3 @ G I N V O K E A L T G G v > G G k " , 5 " $ v "
oTrlHi t P > G G # ) , ) _ v )
Rh > G G $ ) G ) v i )
dݬ > G G k " G "
v "
oTrlH P G G G @ 88 0 2 , F k " , 5
k > ,
F k " ,
+ T P h V t \ R b n ^ ^ ` T v T N T t X \ P R n R j P L ^ Z L X b f Z b \ \ X | 0 0 9b
I +, L G 3 K G G * C R E A T E / A L T E R F U N C T I O N I G & > I G t " , " n 0 0 & IF K K n d m _ d b _ m i s s i n g _ i n d e x _ c o l u m n s "
+1,R > I G ) " , " D & & D d m _ d b _ m i s s i n g _ i n d e x _ c o l u m n s "
6y9 > I G " , " D & & D d m _ d b _ m i s s i n g _ i n d e x _ c o l u m n s "
3#{ > I G z " , "
&
"
g,
> I G < < ^ 0 & 8 CREATE FUNCTION sys.dm_db_missing_index_olumns (@handle int)
RETURNS TABLE
AS
RETURN SELECT *
FROM OPENROWSET(TABLE MISSING_IDX_COLUMNS, @handle)
<
/(
l o g > I G $ )
) C n 0 - & 88
C @ h a n d l e )
h > I G F ) 8 ) 6& @ h a n d l e )
{ Tw > I G $ ) I ) G - & 88
G c o l u m n _ i d )
ēPe > I
G G ) I ) $ r 6& $ c o l u m n _ i d )
1<:NR s p > I G % ) I
) K 0 - & @ 4 @ K c o l u m n _ n a m e )
t > I G H ) I ) ( 6& ( c o l u m n _ a m e )
dx > I
G & ) I ) M 0 - & @ 4 @ M c o l u m n _ u s a g e )
qp > I G I ) I
) * 6& * c o l u m n _ u s a g e i )
: > I G t " I " r s & "
+1,F > I G t " " P & "
+1,N s p P I G K I G f u l P
` `8p X 0 H0 H0 t s p _ S e t S D S P u b l i c I n t e r f a c e O b j e c t 0 0 V H R X d m _ a u d i t _ a c t i o n s 0 0 P \ s p _ a p p r o l e p a s s w o r d 0 0 # P In0c O L G 3 e K G I N V O K E A L T O G & > O G t " I " $ K e " & "
+1, > O G $ ) I ) _ o & )
ēPe> > O G % ) O ) d _ & i )
t l u m > O G & ) O ) " & )
q_ d b > O G ' ) O ) & )
h" > O G t " O "
& "
+1, P O G e O K lumns 888 0 URNS TABLE
AS
RETURN SELECT *
FROM OPENROWSET(TABLE MISSING_IDX_COLUMNS, @handle)
<
/(
l o g > I G $ )
) C n 0 - & 88
C @ h a n d l e )
h > I G F ) 8 ) 6& @ h a n d l e )
{ Tw > I G $ ) I ) G * d2 4 R i L G 3 Q G " C R E A T E / A L T E R V I E W G R G WQ) > R G t # " O " n 0 0 WQ) V n d m _ d b _ m i s s i n g _ i n d e x _ d e t a i l s & "
|e > R G * " I " D & WQ) D d _ d b _ m i s s i n g _ i n d e x _ d e t a i l s "
% > R G " I " D & WQ) D d m _ d b _ m i s s i n g _ i n d e x _ d e t a i l s "
Qf > R G z # " I "
WQ) "
0S/\ > R G < < 0 WQ) 8 CREATE VIEW sys.dm_db_missing_index_details AS
SELECT *
FROM OpenRowset(TABLE MISSING_IDX_DETAILS)
<
=8(T > R G ( ) ) M 0 - WQ) 88
M i n d e x _ h a n d l e 88 )
K1-[ > R G ) I ) * 6WQ) * i n d e x _ h a n d l e )
+4 > R G ( ) R ) K $ 0 - WQ) 44 K d a t a b a s e _ i d )
D u m n > R
G ) R ) ( 6WQ) ( d a t a b a s e _ i d )
ckK_ > R G ( ) R
) G 0 - WQ) 88
G o b j e c t _ i d )
RI5 n > R G ) R ) $ H 6WQ) $ o b j e c t _ i d )
C=ic o l >
G ( ) R ) U & 0 - WQ) @ 4 @ U e q u a l i t y _ c o l u m n s )
jl͞ a > R G ) R
) 2 6WQ) 2 e q u a l i t y _ c o l u m n s c )
Vi > R G ( ) R ) Y 0 - WQ) @ 4 @ Y i n e q u a l i t y _ c o l u m n s G )
+ > R G ) R ) 6 p 6WQ) 6 i n e q u a l i t y _ c o l u m n s )
)lK L G 3 R G G p S p l i t P a g e b i c I 2 R G o ) #
o 2 R G ( ) R
( 2 R G ) G
s
0 # > R G ) , # c -
g 0 @H
) @ R G ) P R G ) ) ( - b l e 2 R G ) ) R
) > R G ) ) R c C ? G E A E E ? G E ; K ? A I G G U I C C M G Q ? A ? A K K K K K K C Q G C I S = A A E M O I I O E M I S K G S ? ? U c I E G G I E [ [ G M W a O Y S q u K K S _ K U K S K E K O I ] Q U C A 0 - X C k e y w o r d 0 - X 88
? c o l i d 0 - X 88
G u n u s e d P i d 0 - X E d o c i d m a x L 0 - X 88
A d u p s e q 0 - X E d o c i d m i n 0 - X E d o c c o u n t 0 0 - X ? d o c i d 0 - X 88
G d o c l e n g t h 0 - X
88
E o c c c o u n t 0 - X 88
; o c c 0 - X 88
K i n t e r n a l P i d 0 - X 88
? @ d b i d 0 - X 88
A @ o b j i d e 0 - X 88
I @ c o m p l e v e l m 0 - 7 G @ r o l e n a m e 0 - v% 88
G o b j e c t _ i d 0 - v% 44 U p r o c e d u r e _ n u m b e r a 0 - v% @ I d e f i n i t i o n 0 - ,+ @ C @ c o o k i e 0 - C k e y w o r d 0 - @ @ M d i s p l a y _ t e r m > 0 - 88
G c o l u m n _ i d 0 - Q d o c u m e n t _ c o u n t 0 - 88
? @ d b i d 0 - 88
A @ o b j i d 0 - VJ ? @ n a m e 0 - VJ bb P A @ v a l u e 0 - VJ K @ l e v e l 0 t y p e 0 - VJ K @ l e v e l 0 n a m e 0 - VJ K @ l e v e l 1 t y p e 0 - VJ K @ l e v e l 1 n a m e 0 - VJ K @ l e v e l 2 t y p e 0 - VJ K @ l e v e l 2 n a m e 0 - 9b C @ d b n a m e 0 - b 00 Q @ n e w _ c m p t l e v e l 0 - d G @ a c c t n a m e 0 - d
C @ o p t i o n 0 - d
I @ p r i v i l e g e ING0 - s x x S p e r m i s s i o n _ n a m e 0 - s = t y p e 0 - s x A @ l e v e l - s A @ p e r m s ) 0 - $ E @ d e v t y p e l 0 - $ M @ l o g i c a l n a m e ) 0 - $ O @ p h y s i c a l n a m e e0 - $ 44 I @ c n t r l t y p e 0 - $ ( I @ d e v s t a t u s 0 - $$ O a g _ re p l i c a _ i d 0 - $$ E a g _ d b _ i d 2 0 - M r e c o v e r y _ l s n 0 - 00 I s y n c _ s t a t e 0 -
hh S @ c r e a t e N e w S t a t e 0 -
88
K @ n e w s t a t e i d 0 -
88
G @ p a r e n t i d 0 -
88
S @ p h r a s e I d O r N u l l 0 -
? @ t e r m 0 -
88
? @ l c i d 0 -
hh U @ n e w S t a t e C r e a t e d 0 -
hh c @ d u p l i c a t e T h e s a u r u s R u l e 0 - Y
I @ f u n c t n a m e H 0 - Y E @ d l l n a m e r0 - _ G @ r o l e n a m e 0 - _ G @ p a s s w o r d 0 - 7 $$ I r e p l i c a _ i d @ 0 - 7 $$ E g r o u p _ i d c 0 - 7 88
[ r e p l i c a _ m e t a d a t a _ i d 0 - 7 4 [ r e p l i c a _ s e r v e r _ n a m e 0 - 7 U U G o w n e r _ s i d 0 - 7 4 M e n d p o i n t _ u r l 0 - 7 00 W a v a i l a b i l i t y _ m o d e 0 - 7 x x a a v a i l a b i l i t y _ m o d e _ d e s c i 0 - 7 00 O f a i l o v e r _ m o d e 0 - 7
x x Y f a i l o v e r _ m o d e _ d e s c `0 - 7 88
S s e s s i o n _ t i m e o u t `0 - 7 00 q p r i m a r y _ r o l e _ a l l o w _ c o n n e c t i o n s a 0 - 7
x 4 x { p r i m a r y _ r o l e _ a l l o w _ c o n n e c t i o n s _ d e s c 0 - 7 00 u s e c o n d a r y _ r o l e _ a l l o w _ c o n n e c t i o n s i 0 - 7 x 4 x s e c o n d a r y _ r o l e _ a l l o w _ c o nn e c t i o n s _ d e s c 0 - 7 == K c r e a t e _ d a t e 0 - 7 == K m o d i f y _ d a t e 0 - 7 88
S b a c k u p _ p r i o r i t y 0 - 7 4 _ r e a d _ o n l y _ r o u t i n g _ u r l 0 - Z 88
K d a t a b a s e _ i d 0 - Z 88
U e n c r y p t i o n _ st a t e 0 - Z == K c r e a t e _ d a t e `0 - Z == S r e g e n e r a t e _ d a t e 0 - Z == K m o d i f y _ d a t e 0 - Z == E s e t _ d a t e 0 - Z == K o p e n e d _ d a t e 0 - Z 4 O k e y _ a l g o r i t h m 0 - Z 88
I k e y _ l e n g t h 0 - Z
] e n c r y p t o r _ t h u m b p r i n t u 0 - Z 4 Q e n c r y p t o r _ t y p e 0 - Z ;; U p e r c e n t _ c o m p l e t e p 0 - ә C @ a c t i o n 0 - ә bb P A @ v a l u e k < R G ( ) R ) a > R G ( ) R _ ) e _ d > R G ) R ( ) c r e > R G o ) R ) e X ) c a n 2 R G ) ) R
2 R G ) R t 2 R G ( ) R 2 R ! G o ) R p P R G R R > R G ( ) R ! ) U 0 - WQ) @ 4 @ U i n c l u d e d _ c o l u m n s )
s. > R $ G ) R ) 2 6WQ) 2 i n c l u d e d _ c o l u m n s _ )
MR ) > R % G ( ) R $ ) G 0 - WQ) @ 4 @ G s t a t e m e n t )
X3 " > R & G ) R % ) $ 6WQ) $ s t a t e m e n t )
|H 0 > R ' G t # " R " WQ) "
|e > R ( G t # " R ( " 2 WQ) "
|e P R G R Q 1@10@0/ /H.---H--,X, ,+(
H X
H p@ PhP 0 j 6v * i n d e x _ h a n d l e > )
6 > , 3 F k " , " v "
oTrlH > , 4 F k " , 4 " v "
oTrlHe r r P , F , : 09 {(R m 4 l -W L G 3 V G I N V O K E A L T l G WQ) > l G t # " R ) " $ WQ) "
|e > l G ( ) R & ) a l WQ) )
K1-[ > l G ( ) l ) b m WQ) i )
Ds > l G ( ) l ) WQ) )
RI5m i s > l G ( ) l ) G WQ) )
jl͞ > l G ( ) l ) WQ) < )
+( WQ) > l G ( ) l ) CT
WQ) t( )
s.ILS)
> l G ( ) l ) WQ) - )
X3 " > l
G t # " l "
WQ) "
|e P l G l V
+408888 0 G ( ) R ) K $ 0 - WQ) 44 D o xZ L G 3 O \ G * C R E A T E / A L T E R F U N C T I O N o G m > o G k " G " d 0 0 m IF O O d d m _ d b _ s t a t s _ p r o p e r t i e s "
]Z) > o G . " R " : & m : d _ d b _ s t a t s _ p r o p e r t i e s
"
La} > o G " R " : Q)& m : d m _ d b _ s t a t s _ p r o p e r t i e s "
Cx > o G z J " R "
m> "
k:t > o G T < 4 < 0 m 8 CREATE FUNCTION sys.dm_db_stats_properties (@object_id int, @stas_id int)
RETURNS TABLE
AS
RETURN SELECT * FROM OPENROWSET(TABLE DM_DB_STATS_PROPERTIES, @object_id, @stats_id)
<
fQPQ) > o G 7 ) ) I # 0 - m 88
I @ o b j e c t _ i d
)
X`. > o G 0 5 ) , . ) & 46m & @ o b j e c t _ i d )
۹pc > o G 7 ) o ) G a0 - m 88
G @ s t a t s _ i d )
Dvn > o
G 0 6 ) o ) $ ) 6m $ @ s t a t s _ i d )
#ܭ
> o G 7 ) o
) G 0 - m 88
G o b j e c t _ i d )
<, > o G 0 7 ) o ) $ 6m $ o b j c t _ i d )
a > o
G 7 ) o ) E 0 - m 88
E s t a t s _ i d )
7c > o G 0 8 ) o
) " t 6m " s t a t s _ i d
)
P.
c > o G 7 ) o ) M 0 - m ** M l a s t _ u p d a t e d )
io > o G 0 7 ) o ) * p 6m * l a s t _ u p d a t e d o )
z+EXI
> o G 7 ) o ) = 0 - m = r o w s )
^ > o G 0 9 ) o ) 6m r o w s )
is > o G 7 ) o ) M - m M r o w s _ s a m p l e d )
5[ > o G 0 : ) o ) * 6m * r o w s _ s a m p l e d b )
3 > o G 7 ) o ) ? 0 - m 88
? s t e p s )
Q > o G 0 < ) o ) c 6m s t e p s )
~/K S K > o G 7 ) o ) S 0 - m S u n f i l t e r e d _ r o w s )
pz > o G 0 = ) o ) 0 6m 0 u n f i l t e r e d _ r o w s )
Rٻ > o G 7
) o ) ] 0 - m ] m o d i f i c a t i o n _ c o u n te r d o )
tuF@ > o G 0 8 ) o ) : 886m : m o d i f i c a t i o n _ c o u n t e r - )
dB`' > o G k " o " m "
]Z88 > o G k " o "
m "
]Z i d P o G O o \ 88 8 `
h 8
X (p@XH 0 7 G @ r o l e n a m e 0 - v% 88
G o b j e c t _ i d 0 - v% 44 U p r o c e d u r e _ n u m b e r a 0 - v% @ I d e f i n i t i o n 0 - ,+ @ C @ c o o k i e 0 - C k e y w o 0%e tm & y q L G 3 j ` G I N V O K E A L T y G m > y G k " o " $ O j " m "
]Z > y G 7 ) o ) i s m
)
<, > y G 7 ) y ) b s m o )
7c" > y G 7 ) y ) m )
%ios _ p > y G 7 ) y ) J m " )
^ m > y G 7 ) y ) < m )
5[ > y G 7 ) y ) in)
m
A )
OM OPE > y G 7 ) y )
QPm )
pz > y
G 7
) y
) Im _ )
tuF@
X` > y G 7 ) y ) 4mm @ )
X`. ) > y G 7 ) y ) m )
Dvn > y
G k " y "
m "
]Z P y G j y ` 888888 0 ) G 0 - m 88
G o b j e c t _ i d )
<, > o G 0 7 ) o ) $ 6m $ o 2 ( * } P 7 + " 5 - = H * " 8 } ) 5 " - ) = I } )
N } " 5 - = o } " } " 5
- = } " B & " B } " B }
" B
} " B } " B }
" B
} " B } " B } " = B } "
B } " B } " } ) Q 5 S - Y = } )
B } ) B } ) B } ) B } ) B } ) B } ) B } ) B } ) B } ) B } )
7 B } ) B } ! ) B } " )
B } # ) B ! } $ ) B " } % ) J } " 5 - = f } " " } ' < i 5 k - q = $ } ( < O } ) < - = @ 1 < E @ } , < E @ } - < E @ } . < E @ } / < @ } 0 < ` 2 G (0'`&%$# #P"! @ p 0` P@p 0
`
P@p 0 K m o d i f y _ d a t e 0 - Z == E s e t _ d a t e 0 - Z == K o p e n e d _ d a t e 0 - Z 4 O k e y _ a l g o r i t h m 0 - Z 8 R * : 7 0 + " 5 - = H * " 8 } xt } 2 } 2 0 H * " 8 } ҸUQ L G 3
G ( D B M g r : : C h a n g e D B S t a t e > G c $ @ 0 k ]E > G c
r : 0 C h a n g e D B S t a t e > G c $ @ 0 z VUQ @ G .%
0
r : 0 C h a n g e D B S t a t e > G c $ @ 0 V$Q P G
0 r : 0 C h a n g e D B S t a t e > G c $ @ 0 % z/ 0 'ؙ L G 3 ۄ G " C R E A T E / A L T E R V I E W a e G > G t " l " d 0 0 V d d m _ d b _ t a s k _ s p a c e _ u s a g e "
3[<g > G / " o " : & : d m _ d b t a s k _ s p a c e _ u s a g e "
[E > G " o " : & : d m _ d b _ t a s k _ s p a c e _ u s a g e "
qc > G z " o "
"
m.;Ih > G < U < 0 @ 8 CREATE VIEW sys.dm_db_task_space_usage AS
SELECT *
FROM OpenRowset(TBLE DM_DB_TASK_SPACE_USAGE)
<
͠s > G k ) ) M 0 - M t a s k _ a d d r e s s )
SIs"& > G ) R ' ) * 6 * t a s k _ a d d r e s s )
4 T4 > G k ) ) Q 0 - hh Q i s _ r e mo t e _ t a s k )
}]o >
G ) ) . 6 . i s _ r e m o t e _ t a s k )
mF`` > G k )
) I 0 - 44 I s e s s i o n _ i d )
J16:c > G ) ) & 6 & s e s s i o n _ i d )
Ws >
G k ) ) I 0 - 88
I r e q u e s t _ i d )
rk > G )
) & 6 & r e q u e s t _ i d )
.N2 > G k ) ) S 0 - 88
S e x e c _ c o n t e x t _ i d )
Xj$ > G ) ) 0 6 0 e x e c _ c o n t e x t _ i d )
Ҏ > G k ) ) K 0 - 88
K d a t a b a s e _ i d )
klDJ > G ) ) ( 6 ( d a t a b a s e _ i d )
=3 > G k ) ) o 0 - o u s e r _ o b j e c t s _ a l l o c _ p a g e _ c o u n t )
/< > G ) ) L 6 L u s e r _ o b j e c t s _ a l l o c _ p a g e _ c o u n t )
"H%G > G k ) ) s 0 - s u s e r _ o b j e c t s _ d e a l l o c _ p a g e _ c o u n t )
&*L >
) >
) 6 ) R 3 L
G 3 ܄ G G S p l i t P a g e 2
G ) , 1
2
G )
2
G $ ) , 3
$ >
G ) c 5
@
1 @
G ) P
G 1 ) $ 2
G 1 ) X
1 > !
G 1 ) ! $ ( H R @ " : 4 ( ( " & 0 : " ( " " $ 2 * ( * . " & $ ( * ( * , & " . " " 0 & : ( & " . . B ( @ " $ ( * ( $ ( $ " $ : & 2 & * ( $ ( 4 ( & : : $ ( & , : : 2 & " & . ( & ( & & & & * ( & ( $ ( 2 2 * 6 $ $ & " " " $ ( " $ $ & $ 2 $ * . ( ( ( ( ( ( . $ & 0 & & " * , 6-' $ @ l o g i n a m e 6-' ( @ n a m e _ i n _ d b 6ʈd H a u t o m a t e d _ b a c k u p _ p r e f e r e n c e 6ʈd R a u t o m a t e d _ b a c k u p _ p r e f e r e n c e _ d e s c 6ʈd @ f a i l u r e _ c o n d i i o n _ l e v e l 6ʈd " g r o u p _ i d 6ʈd : h e a l t h _ c h e c k _ t i m e o u t 6ʈd n a m e 6ʈd 4 r e s o u r c e _ g r o u p _ i d 6ʈd ( r e s o u r c e _ i d 6 ( @ f u t u r e o n l y 6 " @ o b j n a m e 67 @ d b n a m e 6co & c l a s s _ t y p e 6co 0 c l a s s _ t y p e _ d e s c 6co : s e c u r a b l e _ c l a s s _ d e s c 6)t " @ e f n a m e 6)t ( @ f u t u r e o n l y 6)t " @ o b j n a m e 6}#| @ a c t i o n 6 " i n d e x _ i d 6 $ o b j e c t _ i d 6 r o w s e t 6I<$ 2 @ a c c e n t s e n s i t i v e 6I<$ @ l c i d 6I<$ * @ q u e r y s t r i n g 6I<$ ( @ s t o p l i s t i d 6I<$ * d i s p l a y _ t e r m 6I<$ . e x p a n s i o n _ t y p e 6I<$ " g r o u p i d 6I<$ k e y w o r d 6I<$ & o c c u r r e n c e 6I<$ $ p h r a s e _ i d 6I<$ ( s o u r c e _ t e r m 6I<$ * s p e c i a l _ t e r m 64B ( @ P r o v i d e r I d 64B * a l g o r i t h m _ i d 64B , a l g o r i t h m _ t a g 64B k e y _ i d 64B & k e y _ l e n g t h 64B " k e y _ n a m e 64B . k e y _ t h u m b p r i n t 64B " k e y _ t p e 6 E " b a t c h _ i d 6 E
0 b a t c h _ t i m e s t a m p 6 E & c a t a l o g _ i d 6 E : c r a w l _ m e m o r y _ a d d r e s s 6 E ( d a t a b a s e _ i d 6 E & d o c _ f a i l e d 6 E " h r _ b a t c h 6 E . i s _ r e t r y _ b a t c h 6 E . m e m o r y _ a d d r e s s 6 E B m e m r e g i o n _ m e m o r y _ a d d r e s s 6 E
( r e t r y _ h i n t s E @ r e t r y _ h i n t s _ d e s c r i p t i o n 6 E " t a b l e _ i d 6& @ h a n d l e 6& $ c o l u m n _ i d 6& ( c o l u m n _ n a m e 6& * c o l u m n _ u s a g e 6+ * @ s r v r o l e n a m e 6Y @ f t c a t 6y c r e a t e d 6y ( d a t a b a s e _ i d 6y i d 6y $ o b j e c t _ i d 6y s i d 6y s t a t u 6y t i m e o u t 6} @ a c t i o n 6} @ f t c a t 6} @ p a t h 6O @ n t n a m e 6E @ d b N a m e 6E ( @ f i l e g r o w t h 6E $ @ f i l e n a m e 6E " @ m a x s i z e 6E @ n a m e 6E @ s i z e 6XZ $ @ t y p e n a m e 6'
: r e a d _ o n l y _ r e p l i c a _ i d 6'
& r e p l i c a _ i d 6'
r o u t i n g _ p r i o r i t y 6UpT c o u n t e r 6UpT & o c c u r r e n c e 6UpT v a l u e 6 * @ s r v r o l e n a m e 6W ( b a t c h _ c o u n t 6W $ f d h o s t _ i d 6W ( f d h o s t _ n a m e 6W 4 f d h o s t _ p r o c e s s _ i d 6W ( f d h o s t _ t y p e 6W & m a x _ t h r e a d 6e : @ c u r r e n t _ c o m p r e s s i o n 6e : @ d e i r e d _ c o m p r e s s i o n 6e $ @ i n d e x _ i d 6e ( @ i n d e x _ n a m e 6e & @ o b j e c t _ i d 6e , @ s a m p l e _ t a b l e 6e : c o m p r e s s _ c u r r e n t _ d d l 6e : c o m p r e s s _ d e s i r e d _ d d l 6e 2 c r e a t e _ i n d e x _ d d l 6e & i s _ p r i m a r y 6>h " a g _ d b _ i d 6>h & a g _ d b _ n a m e 6>h a g _ i d >h . t r u n c a t i o n _ l s n 6U} ( d a t a b a s e _ i d 6U} & e r r o r _ c o d e 6U} ( i n _ p r o g r e s s 6U} j o b _ i d 6U} & o b j e c t _ i d 1 6U} & o b j e c t _ i d 2 6U} & o b j e c t _ i d 3 6U} & o b j e c t _ i d 4 6U} * r e q u e s t _ t y p e 6U}
( r e t r y _ c o u n t 6U} & s e s s i o n _ i d 6U} ( t i m e _ u e u e d 6z $ @ r e s a m p l e 6WQ) ( d a t a b a s e _ i d 6WQ) 2 e q u a l i t y _ c o l u m n s 6WQ) 2 i n c l u d e d _ c o l u m n s 6WQ) * i n d e x _ h a n d l e 6WQ) 6 i n e q u a l i t y _ c o l u m n s 6WQ) $ o b j e c t _ i d 6WQ) $ s t a t e m e n t 6X & @ c o m p l e v e l 6X @ d b i d 6X @ o b j i d 6X c o l i d 6X " d c c o u n t 6X d o c i d 6X " d o c i d m a x 6X " d o c i d m i n 6X $ d o c l e n g t h 6X d u p s e q 6X ( i n t e r n a l P i d 6X k e y w o r d 6X o c c 6X
" o c c c o u n t 6X $ u n u s e d P i d 67 $ @ r o l e n a m e 6v% & d e f i n i t i o n 6v% $ o b j e c t _ i d 6v% 2 p r o c e d u r e _ n u m b e 6,+ @ c o o k i e 6 @ d b i d 6 @ o b j i d 6 $ c o l u m n _ i d 6 * d i s p l a y _ t e r m 6 . d o c u m e n t _ c o u n t 6 k e y w o r d 6VJ ( @ l e v e l 0 n a m e 6VJ ( @ l e v e l 0 t y p e 6VJ ( @ l e v e l 1 n a m e 6VJ ( @ l e v e l 1 t y p e 6VJ ( @ l e v e l 2 n a m e 6VJ ( @ l e v e l 2 t y p e 6VJ @ n a m e 6VJ @ v a l u e 69b @ d b n a m e 69b . @ n e w _ c m p t l e v e l 6d $ @ a c c t n a m e 6d @ o p t i o n 6d & @ p r i v i l e g e 6s @ l e v e l 6s @ p e r m s 6s 0 p e r m i s s i o n _ n a m e 6s t y p e 6$ & @ c n t r l t y p e 6$ & @ d e v s t a t u s 6$ " @ d e v t y p e 6$ * @ l o i c a l n a m e 6$ , @ p h y s i c a l n a m e < "
G ) 1 > #
G ) # $ 1 > $
G $ ) 1 ..@.H hx0H0
( x
0 p0x8P@ 0 ..@.H hx0H0
( x
0 pg roq6s2s6y_dt* A_ 0 %] > %
G ) ) & 6-' 1 & @ l o g i n a m e 2
G 1 ) " 2
G $ ) % 2
G ) $ 2
G ) P
G ܄ > G ) ) P 6 P u s e r _ o b j e c t s _ d e a l l o c _ p a g e _ c o u n t )
JU| > G k ) ) w 0 - w i n t e r n a l _ o b j e c t s _ a l l o c _ p a g e _ c o u n t )
jA.v@ > G ) ) T 6 T i n t e r n a l _ o b j e c t s _ a l l o c _ p a g e _ c o u n t )
#^n Lx > G k ) ) { 0 -
{ i n t e r n a l _ o b j e c t s _ d e a l l o c _ p a g e _ c o u n t )
^o >
G ) ) X 6
X i n t e r n a l _ o b j e c t s _ d e a l l o c _ p a g e _ c o u n t )
\q@ > G t " " "
3[<g > G t " " "
3[<g P G ۄ (`H 0 b
? > c 9 ))
0 1 . /3==CSSSSSSScccmw)Ud}Kޟ& @ @ ?v%Oqn Z l o g 0 1 . /3==CSSSSSSScccmw)Ud}Kޟ& @ @ ?v%Oqn Z l o g ) H 0 ) S 0 - 88
S e x e c _ c o n t e x t _ i d )
Xj$ > G l
6 L G 3 G I N V O K E g i n G > G t "
" $ 2 "
3[<g > G k )
) )
SIs"& > G k ) ) ) )
}]ou s e > G k ) ) | > )
J16:c > G k ) ) i nt e j )
rk p a g > G k ) ) )
Xj$ > G k ) )
> )
klDJ > G k ) ) e )
/< s _ d >
G k )
) G )
&*L > G k ) ) a e )
jA.v@> > G k ) )
)
^o L G G " S e t F i l e S i z e P > G ? (
aj@ >
G t " "
"
3[<g P G P G 888888 0
L
G 3 4
G " C R E A T E / A L T E R V I E W
G #st >
G i " " d 0 0 #st V 4 4 d d m _ d b _ f i l e _ s p a c e _ u s a g e "
E3ev%O >
G ( " " : & #st : d m _ d b f i l e _ s p a c e _ u s a g e "
zB2 >
G " " : & #st : d m _ d b _ f i l e _ s p a c e _ u s a g e "
#7[ >
G z " "
#st "
KWK >
G w < ! < 0 #st @ 8 CREATE VIEW sys.dm_db_file_space_usage AS
SELECT *
FROM OpenRowset(TBLE DM_DB_FILE_SPACE_USAGE)
<
ߪ8 >
G ` > ) ] ) K 0 - #st 88
K d a t a b a s e _ i d )
1D /3 >
G O m ) ] ' ) ( 6#st ( d a t a b a s e _ i d )
w\"A >
G ` ? ) ) C 0 - #st 44 C f i l e _ i d )
< /m >
G O n ) ) 6#st f i l e _ i d )
i/wZ= >
G ` @ )
) M 0 - #st 44 M f i l e g r o u p _ i d )
pt >
G O o ) ) * 6#st * f i l e g r o u p _ i d )
5 m >
G ` A ) ) U 0 - #st U t o t a l _ p a g e _ c o u n t )
UC1 >
G O p )
) 2 6#st 2 t o t a l _ p a g e _ c o u n t )
* H >
G ` B ) ) k 0 - #st k a l l o c a t e d _ e x t e n t _ p a g e _ c o u n t
)
*( >
G O m ) ) H 6#st H a l l o c a t e d _ e x t e n t _ p a g e _ c o u n t )
i!4_)! >
G ` C ) ) o 0 - #st o u n a l l o c a t e d _ e x t e n t _ p a g e _ c o u n t )
-)1 >
G O r ) ) L 6#st L u n a l l o c a t e d _ e x t e n t _ p a g e _ c o u t )
b 3? >
G ` D ) ) w 0 - #st w v e r s i o n _ s t o r e _ r e s e r v e d _ p a g e _ c o u n t )
3am =l >
G O s ) ) T 6#st T v e r s i o n _ s t o r e _ r e s e r v e d _ p a g e _ c o u n t )
´W+ s u s >
G ` E ) ) s 0 - #st s u s e r _ o b j e c t _ r e s e r v e d _ p a g e _ c o u n t )
gh; >
G O s ) ) P 6#st P u s e r _ o b j e c t _ r e s e r v e d _ p a g e _ c o u n t )
C >
G ` F ) ) { 0 - #st { i n t e r n a l _ o b j e c t _ r e s e r v e d _ p a g e _ c o u n t
)
C+ >
G O q ) ) X 6#st X i n t e r n a l _ o b j e c t _ r e s e r v e d _ p a g e _ c o u n t )
z >
G ` G ) ) c 0 - #st
c m i x e d _ e x t e n t _ p a g e _ c o u n t )
-#=k" : >
G O r ) ) @ " 6#st
@ m i x e d _ e t e n t _ p a g e _ c o u n t )
eHh_( >
G i " " & #st "
E3e2 >
G i " " @ o #st "
E3e@ n a P
G 4 n c e (88
p
( Hp8P@ 0 e r e n c e _ d e s c 6ʈd @ f a i l u r e _ x n A_ & ށB L G 3 R G I N V O K E g i n G #st > G i " " $ 4 R 2 #st "
E3e > G ` > ) ) #st )
1D > G ` ? ) ) ) #st )
< /mu s e > G ` @ ) ) | > #st )
pt > G ` A ) ) i nt e#st j )
UC1 p a g > G ` B ) ) #st )
*( > G ` C ) )
#st > )
-)1 > G ` D ) ) #st e )
3am = s _ d >
G ` E )
) G #st )
gh; > G ` F ) ) a e #st )
C+> > G ` G ) ) #st
)
-#=k >
G i " "
" #st "
E3e> P G R 888888 0
G t " "
"
3[<g P G P \ }8 L G 3 G " C R E A T E / A L T E R V I E W G Be > G t " " j 0 0 Be V j d m _ d b _ s e s s i o n _ s p a c e _ u s a g e " "
M|> > G / " " @ #s& Be @ d _ d b _ s e s s i o n _ s p a c e _ u s a g e "
FgD > G " " @ #s& Be @ d m _ d b _ s e s s i o n _ s p a c e _ u s a g e "
1{wH > G z " "
#s Be" "
{͐> > G Q < < st0 Be @ 8 CREATE VIEW sys.dm_db_session_space_usage AS
SELECT *
FROM penRowset(TABLE DM_DB_SESSION_SPACE_USAGE)
<
|> > G < ) O ) I 880 - Be 44 I s e s s i o n _ i d
)
|O > G 1 P ) ) & 6Be & s e s s i o n _ i d
)
p^:r > G = ) ) K 440 - Be 88
K d at a b a s e _ i d )
R- >
G 1 P ) ) ( l 6Be ( d a t a b a s e _ i d )
@ > G > )
) o 0 - Be o u s e r _ o b j e c t s _ a l l o c _ p a g e _ c o u n t )
9W6! > G 1 R ) ) L 6Be L u s e r _ o b j e c t s _ a l o c _ p a g e _ c o u n t )
fN5) >
G ? ) ) s ) 0 - Be s u s e r _ o b j e c t s _ d e a l l o c _ p a g e _ c o u n t )
ŨZT > G 1 S )
) P 6Be P u s e r _ o b j e c t s _ d e a l l o c _ p a g e _ c o u n t )
FKt e > G @ ) ) 0 - Be w i n t e r n a l _ o b j e c t s _ a l l o c _ p a g e _ c o u n t )
<eIX
> G 1 Q ) ) T 6Be T i n t e r n a l _ o b j e c t s _ a l l o c _ p a g e _ c o u n t )
8 _ c o > G A ) ) { 0 - Be { i n t e r n a l _ o b j e c t s _ d e a l l o c _ pa g e _ c o u n t
)
K{ > G 1 R ) ) X 6Be X i n t e r n a l _ o b j e c t s _ d e a l l o c _ p a g e _ c o u n t )
c !) > G t " " Be "
M|i o n > G t " " u s > Be "
M| P G s u s
`
0 P
80HXH 0 e _ c o u n t )
gh; >
G O s ) ) P 6#st P u s e r _ o b j e c t _ r e s e r v e d _ p a g e _ c o u n t )
C >
G ` F ) ) { 0 - #st { i n t e r n a l _ o b j e c t _ r e s e r v e d _ p a g e _ c o u n wl Om `e L G 3 G I N V O K E g i n G Be > G t " " $ 2 Be "
M| > G < ) ) Be )
|O > G = ) ) ) Be )
R-u s e > G > ) ) | > Be )
9W6! > G ? ) ) i nt eBe j )
ŨZT p a g > G @ ) ) Be )
<eIX > G A ) )
Be > )
K{ > G t " "
Be "
M|
3am P G 8888 0 )
gh; > G ` F ) ) a e #st )
C+> > G ` G ) ) ͳ L G 3 < G " C R E A T E / A L T E R V I E W G j > G t " "
" b 0 0 j V < < b d m _ d b _ l o g _ s p a c e _ u s a g e s "
+q짘
M > G * " " 8 & j 8 d m _ d b l o g _ s p a c e _ u s a g e "
c`[v" > G " " 8 & j 8 d m _ d b _ l o g _ s p a c e _ u s a g e "
k"e > G z " " "
j "
gG%:" > G < T - < 0 j @ 8 CREATE VIEW sys.dm_db_log_space_usage AS
SELECT *
FROM OpenRowset(TABLE DM_DB_LOG_SPCE_USAGE)
<
"CE_USA > G Y ) ) K 0 - j 88
K d a t a b a s e _ i d )
CXt _ i d > G 1 m ) ) ( 6j ( d a t a b a s e _ i d )
Zĩn > G Z ) ) c 0 - j c t o t a l _ l o g _ s i z e _ i n _b y t e s e )
xmG
R >
G 1 n ) ) @ 6j @ t o t a l _ l o g _ s i z e _ i n _ b y t e s )
H,;7 > G [ )
) c 0 - j c u s e d _ l o g _ s p a c e _ i n _ b y t e s )
@> > G 1 o ) ) @ 6j @ u s e d _ l o g _ s p c e _ i n _ b y t e s )
{.N5 >
G \ ) ) g 0 - j ;; g u s e d _ l o g _ s p a c e _ i n _ p e r c e n t p )
1α > G 1 p )
) D 6j D u s e d _ l o g _ s p a c e _ i n _ p e r c e n t )
QgNV e _ c > G t " " " ) j "
+q짘 > G t " " " o c _ pj "
+q짘
P G < e
0(`(@8 0 c t s _ a l l o c _ p a g e _ c o u n t )
8 _ c o > G A ) ) { 0 - Be { i n t e r n a l _ o b j e c t s _ d e a l l o a A_ ? L G 3 Y G I N V O K E g i n G j > G t " " " $ < Y 2 j "
+q짘 > G Y ) ) j )
CXt > G Z ) ) ) j )
xmGu s e > G [ ) ) | > j )
@ > G \ ) ) i nt ej j )
1α p a g > G t " " "
j "
+q짘
<eI P G Y 888 0 > )
K{ > G t " "
Be "
M|
3am P G 8888 0 )
gh; > G ` F ) ) a e #st )
C+> > G ` G ) ) . , pU L G 3 G * C R E A T E / A L T E R F U N C T I O N G $( > G h " , " r 0 0 $( IF r d m _ d b _ i n d e x _ o p e r a t i o n a l _ s t a t s
"
ٵsQ > G ) " " H b $( H d m _ d b _ i n d e x _ o p e r a t i o n a l _ s t a t s "
(d > G " " H a & $( H d m _ d b _ i n d e x _ o p e r a t i o n a l _ s t a t s "
(i
> G z g " "
$( "
a<t< > G < < p lo0 $( p8 create function sys.dm_db_index_perational_stats
(
@DatabaseId SMALLINT = 0,
@TableId INT = 0,
@IndexId INT = -1,
@PartitionNumber INT = 0
)
returns table
as
return select *
from OpenRowset
( TABLE
VIRTUALINDEXSTATS,
@DatabaseId,
@TableId,
@IndexId,
@PartitionNumber)
<
J K d > G < ) 6 G ) K 0 - $( 44 K @ D a t a b a s e I d c )
PR? i z e > G ' & ) 6 H ) ( 6$( ( @ D a t a b a s e I d )
ɋ > G < ) ) E 0 - $( 88
E @ T a b l e I d )
f4xZ >
G ' ' ) ) " e6$( " @ T a b l e I d > )
Rs[ o > G < )
) E o 0 - $( 88
E @ I n d e x I d )
I*_ￏ > G ' ' ) ) " 6$( " @ I n d e x I d a )
;vy( n t p >
G < ) ) U 0 - $( 88
U @ P a r t i t i o n N u m b e r e )
qhfN > G ' ( )
) 2 6$( 2 @ P a r t i t o n N u m b e r )
<OG > G < ) ) K 0 - $( 44 K d a t a b a s e _ i d )
nC2 > G ' * ) ) ( e 6$( ( d a t a b a s e _ i d )
m6W > G < ) ) G 0 - $( 88
G o b j e c t _ i d l )
(!@ n > G ' + ) ) $ 6$( $ o b j e c t _ i d )
sxr n a > G < ) ) E
0 - $( 88
E i n d e x _ i d )
m+be > G ' + ) ) " 6$( " i n d e x _ i d )
Q" > G < ) ) U 0 - $( 88
U p a r t i t i o n _ n u m b e r u n )
H h; > G ' - ) ) 2 6$( 2 p a r t i t i o n _ n u m b e r r )
mx
e _ c > G < ) ) W 0 - $( W l e a f _ i n s e r t _ c o u n t n )
w c > G ' , ) ) 4 6$( 4 l e a f _ i n s e r t _ c o u n t )
4st > G < ) ) W c 0 - $( W l e a f _ d e l e t e _ c o u n t )
0Y/Gt > G ' , ) ) 4 p6$( 4 l e a f _ d e l e t e _ c o u n t )
r > G < ) ) W e - $( W l e a f _ u p d a t e _ c o u n t )
|2K > G ' . ) ) 4 6$( 4 l e a f _ u p d a t e _ c o u n t )
W2o #st > G <
) ) U 0 - $( U l e a f _ g h o s t _ c o u n t )
z7r > G ' - ) ) n 6$( 2 l e a f _ g h o s t _ c o u n t d )
L/Nt h _ > G < ) ) ] 0 - $( ] n o n l e a f _ i n s e r t _ c o u n t @ )
y6\ > G ' 0 ) ) : 6$( : n o n l e a f _ i n s e r t _ c o u n t s )
ۮD!öo > ! G < ) ) ] @ - $(
] n o n l e a f _ d e l e t e _ c o u n t }#| )
r i > " G ' 0 ) ! ) : _ 6$(
: n o n l e a f _ d e l e t e _ c o u n t c )
_Prv e > # G <
) " ) ] 0 - $( ] n o n l e a f _ u p d a t e _ c o u n t )
`N2n > $ G ' 2 ) # ) : y 6$( : n o n l e a f _ u p d a t e _ c o u n t )
B(Պd 6I<$ > % G < ) $ ) _ t 0 - $( _ l e a f _ a l l o c a t i o n _ c o u n t B )
Xk.^dr > & G ' , ) % ) < y 6$( < l e a f _ a l l o c a t i o n _ c o u n t )
kfu m b > ' G < ) & ) e t 0 - $(
e n o n l e a f _ a l l o c a t i o n _ c o u n t E )
'Ehl > ( G ' 1 ) ' ) B d 6$(
B n o n l e a f _ a l l o c a t i o n _ c o u n t a )
oU . i > ) G < ) ( ) _ s 0 - $( _ l e a f _ p a g e _ m e r g e _ c o u n t )
k > * G ' 0 ) ) ) < 6$( < l e a f _ p a g e _ m e r g e _ c o u n t )
eu_ i d > + G < ) * ) e _ 0 - $( e n o n l e a f _ p a g e _ m e r g e _ c o u n t )
_ > , G ' 5 ) + ) B 6$( B n o n l e a f _ p a g e _ m e r g e _ c o u n t a )
\ t > - G < ) , ) U a 0 - $( U r a n g e _ s c a n _ c o u n t b )
& p H8xxXp h
@
h
0
X(Hx` 0 e 6E @ n a m e 6E @ s i z e 6XZ $ @ t y p e n a m e 6'
: r e a p H8xxXp h
@
h
0
X( A020 io& # K L \m 0 ` ?; % & k
?; # 5 - =
?; $ A R g A S A T
A U A V A W A X
A Y A Z A [
A \
A ]
A ^
A _
A ` A a A b A c A d
A e A f
A g A h A i A j A k A l A m A n A o ! A p " JII@HpGFE E0D`CBA@ @P?>=<<@;p:98 807`6543 3P210P00 R L 6 l 0 0 7 B/ & 0 8 & L k 3 & , k S h r i n k F i l e 8 k 8 k 0
9 ]< > c ; ))
0 1 . /3==CSSSSSSScccmw)Ud}Kޟ& @ @ @ ?v%Oqn Z l o g 0 1 . /3==CSSSSSSScccmw)Ud}Kޟ& @ @ ?v%Oqn Z l o g 0
> .
P 8 k & 8 , 0 ^ ? =Ǽ L
k 3 & ,
k F i l e S i z e > ?
k V;
aj@ @ ?
k % ? & 0 @ . P ?
k & ? , 0 " A
5 - =
A R # A S A A T A
A U A A V A A W A A X A A Y A A Z A
A [ A
A \ A
A ] A
A ^ A
A _ A
A ` A A a A A b A A c A A d A
A e A A f A
A g A A h A A i A A j A A k A A l A A m A A n A A o A A p A ` &
k 0` P@p 0
`
P@p 0 R O < 0 0 P p/ A " & A " 0 Q *\Q L k 3
o z k ( D B M g r : : C h a n g e D B S t a t e > Q k c 2 $ @ 0 R }_E > Q k c Q A" o r : 0 C h a n g e D B S t a t e > Q k c 2 $ @ 0 z S |^Q @ R k & Q o 0 A" o r : 0 C h a n g e D B S t a t e > Q k c 2 $ @ 0 T Q P Q k o Q z o 0 r : 0 C h a n g e D B S t a t e > Q k c 2 $ @ 0 U g6 L k 3 wo )z k D R O P O B J C a U k > U k " $ " $ yo "
qϜ U k
, U k
; > U k ( < < ? 0 @ ?8 CREAE VIEW sys.sac_state AS
SELECT component_name,
convert(sysname, N'mssqlsystemresource') collate catalog_default AS database_name,
schema_name collate catalog_default AS schema_name,
object_name collate catalog_default AS object_name,
state, type
FROM sys.obd_state
<
#v 6 < 4; c > U k s ) ) . 6 . c o m p o n e n t _ n a m e )
A5 6 ) U # > U k 4 ) # ) Q 0 - 4 Q c o m p o n e n t _ n a m e )
U 6 ) U > U
k t ) U ) , 6 , d a t a b a s e _ n a m e )
X0 > U k 4 ) U
) O 0 - O d a t a b a s e _ n a m e )
aP\ > U
k v ) U ) ( 6 ( s c h e m a _ n a m e )
M\k > U k 4 ) U
) K 0 - K s c h e m a _ n a m e )
-
P > U k u ) U ) ( 6 ( o b j e c t _ n a m e )
+Z > U k 4 ) U ) K 0 - K o b j e c t _ n a m e )
% > U k w ) U ) 6 s t a t e )
L0 > U k 4 ) U ) ? 0 - 00 ? s t a t e )
/D<) > U k x ) U ) 6 t y p e )
Hf > U k 4 ) U ) = 0 - = t y p e )
p > U k F > " " & s a c _ s t a t e "
۷ 6 " U S
> U k M = " Z " & s a c _ s t a e "
/pH 6 " U
> U k " 2 "
"
SG7 6 " U O > U k " U " J 0 0 V yo J s a c _ s t a t e "
qϜ 6 " U U k P U k }o U )z
X h
H
0 X 8 p8h8 0 t T 3 & ( ] @R. L k 3 o 8z k " C R E A T E / A L T E R V I E W k ] k > ] k " U " J 0 0 V o o J s a c _ s t a t e "
qϜ
6 " U > ] k F > " U " W & s a c _ s t a t e "
۷ys 6 " ] S
> ] k M = " U "
& s a c _ s t a t e "
/pH
6 " ]
> ] k " U "
"
SG7 6 " ] O L k 3 o 9z k k S p l i t P a g e 2 ] k < 4;
-
2 ] k ( < U
a
( ) 2 ]
k <
6 ] k < ; > ] k < ]
c
> ] k < ] c
@
6 ] k
< 8
@ ] k < 6 c ; P ] k
< ( 0 - 2 ] k
< ]
e
m e > ] k
< ] ?n|r < @ ?8 CREATE VIEW sys.sac_state AS
SLECT component_name,
convert(sysname, N'mssqlsystemresource') collate catalog_default AS database_name,
schema_name collate catalog_default AS schema_name,
object_name collate catalog_default AS object_name,
state, type
FROM sys.obd_state
0
@ n8 CREATE VIEW sys.master_key_passwords AS
SELECT
co.id AS credential_id,
convert(uniqueidentifier,
stringtovarbinary(convert(varchar(128),
SUBSTRING ( co.name,
charindex('_', co.name) + 1,
charindex('_', co.name, charindex('_', co.name) + 1) - charindex('_', co.name) - 1)
) ) ) AS family_guid
FROM master.sys.sysclsobjs co
LEFT JOIN master.sys.sysobjvalues ov ON ov.valclass = 28 AND ov.objid = co.id AND ov.subobjid = 0 AND ov.valnum = 1
WHERE co.class = 57
AND has_access('CR', 0) = 1 AND co.name LIKE '##DBMKEY_%'
0 |8 CREATE VIEW sys.database_recovery_status AS
SELECT d.id AS database_id,
p.database_guid,
p.family_guid,
p.last_log_backup_lsn,
p.recovery_fork_guid,
p.first_recovery_fork_guid,
p.fork_point_lsn
FROM master.sys.sysdbreg d OUTER APPLY OpenRowset(TABLE DBRECOVER, d.id) p
WHERE d.id < 0x7fff
AND has_access('DB', d.id) = 1
0 @ r8 CREATE VIEW sys.database_mirroring AS
SELECT d.id AS database_id,
p.guid AS mirroring_guid,
p.state AS mirroring_state, p.state_desc AS mirroring_state_desc,
p.role AS mirroring_role, p.role_desc AS mirroring_role_desc,
p.role_seqence AS mirroring_role_sequence,
p.safety_level AS mirroring_safety_level,
p.safety_level_desc AS mirroring_safety_level_desc,
p.safety_sequence AS mirroring_safety_sequence,
p.partner_name AS mirroring_partner_name,
p.partner_instance AS mirroring_partner_instance,
p.witness_name AS mirroring_witness_name,
p.witness_state AS mirroring_witness_state,
p.witness_state_desc AS mirroring_witness_state_desc,
p.failover_lsn AS mirroring_failover_lsn,
p.connection_timeout AS mirrorin_connection_timeout,
p.redo_queue AS mirroring_redo_queue,
p.redo_queue_type AS mirroring_redo_queue_type,
p.end_of_log_lsn AS mirroring_end_of_log_lsn,
p.safe_relication_lsn AS mirroring_replication_lsn
FROM master.sys.sysdbreg d OUTER APPLY OpenRowset(TABLE DBMIRROR, d.id) p
WHERE d.id < 0x7fff
AND has_access('DB', d.id) = 1
0 @ 8 CREATE VIEW sys.credentials AS
SELECT
co.id AS credential_id,
co.name,
convert(nvarchar(4000), ov.value) as credentia_identity,
co.created as create_date,
co.modified as modify_date,
n.name as target_type,
r.indepid AS target_id
FROM master.sys.sysclsobjs co
LEFT JOIN master.sys.sysobjvalues ov ON ov.valclass = 28 AND ov.objid = co.id AND ov.subobjid = 0 AND ov.valnum = 1
LEFT JOIN master.sys.syssingleobjrefs r ON r.depid = co.id AND r.class = co.intprop AND r.depsubid = 0
LEFT JOIN sys.syspalvalues n ON n.class = 'SRCL' AND n.value = co.intprop
WHERE co.class = 57
AND has_access('CR', 0) = 1
6 < ] l < ] k ( < ]
D + > ] k ( < ]
> ] k < ] (
> ] k < ] <
2 ] k
< ] 2 ] k < ] 2 k ( < ] 2 ] k < ] P ] k o ] 9z > ] k
< ] < [ 0 [8 CREATE VIEW sys.sac_state AS
SELECT component_name,
convert(sysname, N'mssqlsystemresource') collate catalog_default AS database_name,
schema_name collate catalog_default AS schema_name,
object_name collat catalog_default AS object_name,
state, type
FROM sys.obd_state
UNION ALL
SELECT convert(sysname, c.name) AS component_name,
convert(sysname, N'master') collate catalog_default AS database_name,
s.name collate catalog_default AS schema_name,
o.name collate catalog_default AS object_name,
convert(tinyint, convert(int, c.value) & 1) AS state,
o.type
FROM master.sys.sysobjkeycrypts k
JOIN master.sys.sysschobjs o ON o.id = k.id
JOIN master.sys.sysxlgns l ON l.type = 'M' AND substrng(l.sid, 13, 28) = k.thumbprint
JOIN master.sys.configurations c ON c.name = substring(l.name, 3, len(l.name) - 4)
LEFT JOIN master.sys.schemas s ON s.schema_id = o.nsid
WHERE k.class = 1 AND k.type = 'INCP'
UNION ALL
SELECT convert(sysname, c.name) AS component_name,
convert(sysname, N'msdb') collate catalog_default AS database_name,
s.name collate catalog_default AS schema_name,
o.name collate catalog_default AS object_name,
convert(tinyint, convert(int, c.value) & 1) AS state,
.type
FROM msdb.sys.sysobjkeycrypts k
JOIN msdb.sys.sysschobjs o ON o.id = k.id
JOIN master.sys.sysxlgns l ON l.type = 'M' AND substring(l.sid, 13, 28) = k.thumbprint
JOIN master.sys.configurations c ON c.name = substring(l.name, 3, len(l.name) - 4)
LEFT JOIN msdb.sys.schemas s ON s.schema_id = o.nsid
WHERE k.class = 1 AND k.type = 'INCP'
<
#v 6 < ] l > ] " k 4 ) U ) Q - 4 Q c o m p o n e n t _ n a m e )
U > ] $ k s ) U ) . 6 . c o m p o n e n t _ n a m e )
A5 > ] % k 4 ) ] $ ) O 0 - O d a t a b a s e _ n a m e )
aP\ > ] & k t ) ] % ) , 6 , d a t a b a s e _ n a m e )
X0 > ] ' k 4 ) ] & ) K 0 - K s c h e m a _ n a m e )
-
P > ] ( k v ) ] ' ) ( 6 ( s c h e m a _ n a m e )
M\k > ] ) k 4 ) ] ( ) K 0 - K o b j e c t_ n a m e )
% > ] * k u ) ] ) ) ( 6 ( o b j e c t _ n a m e )
+Z > ] + k 4 ) ] * ) ? 0 - 00 ? s t a t e )
/D<) > ] , k w ) ] + ) 6 s t a t e )
L0 > ] - k 4 ) ] , ) = 0 - = t y p e )
p 6 ) ] # > ] . k x ) ] - ) 6 t y p e )
Hf 6 ) ] / # > ] 0 k " ] " "
qϜ P ] k o ] 8z %`%(%$p$#P#"("x! @ p h0(x8 p(X` H0x@ 0 0oie] lgu
E 2 ( * ( q f G J A " ) 5 + - 1 = f A "
q " ? 5 A - A = q "
B 2 " " :
B q " :
B q " :
B
q " :
B q " "# B q " :
B
q
" :
B q " :
B q "
B q
"
:
B q " B q "
q ) 5 - = q ) P B q ) R B q ) R B q ) R B q ) R B q ) /R B q ) /R B q ) /R B q ) /R B q ) /R B q )
fR B q ) B q ) /R B q )
!R B q ) R B ! q ) R B " q ! ) $R " q < 5 - = $ q < N O q # < - = @ ?; < @ q & < @ q ' < @ q ( < @ q ) < @ q * < N q % " 5 - = o q $ "
7 q , " , 5 . - 1 = H q - "
8 q . ) 5 - = I q / ) P ` A " "p k (0'`&%$# #P"! @ p 0` P@p 0
`
P@p 0 R *
: J 0 A " ) 5 + - 1 = f A "
q ax q 2 "p q 2 0 f A "
q