|
lct_admin("lastchance")
The
system function
lct_admin("lastchance") creates a
LCT, Last Chance Threshold
(Last Chance Threshold) in the
database
provided with the parameter db_id .
lct_admin() is a
Transact-SQL
extension. (See also overview:
lct_admin()).
Syntax of the system function lct_admin("lastchance")
lct_admin("lastchance", db_id)
The parameters of the system function lct_admin("lastchance")
"db_id"
The parameter "db_id"
is used to specify the database where the
log segment
has crossed the and which is in
LOG SUSPEND
mode. The db_id can be extracted from the
column
dbid in the
system table
sysdatabases
or using the
stored procedure
sp_helpdb.
Example for using the system function lct_admin("lastchance")
select lct_admin("lastchance", 4)
go
Creates the LCT for the log segment of the
database
with db_id 4. The return value displays the number of free pages before the
threshold
is crossed..
Existing thresholds on the log segment will be overwritten.
See also:
dump transaction,
sp_thresholdaction,
audit_event_name(),
col_length(),
col_name(),
curunreservedpgs(),
data_pages(),
data_pgs(),
datachange,
datalength(),
db_id(),
db_name(),
derived_stat,
host_id(),
host_name(),
identity(),
identity_burn_max(),
index_col(),
index_colorder(),
is_quiesced(),
isnull(),
lct_admin(),
license_enable(),
lockscheme(),
next_identity(),
object_id(),
object_name(),
pageinfo(),
pagesize(),
partition_id(),
partition_name(),
partition_object_id(),
pointer_size(),
pnt_data_pgs(),
pssinfo(),
reserved_pages(),
reserved_pgs(),
row_count(),
rowcnt(),
showplan_in_xml(),
syb_quit(),
syb_sendmsg(),
tempdb_id(),
tran_dumptable_status(),
tsequal(),
used_pages(),
used_pgs()
and
Funktions.
See also:
ASE T-SQL - Aggregate Functions,
audit_event_name(),
col_length(),
col_name(),
curunreservedpgs(),
datachange(),
datalength(),
data_pages(),
data_pgs(),
db_id(),
db_name(),
host_id(),
host_name(),
identity(),
index_col(),
index_colorder(),
isnull(),
lct_admin(),
license_enabled(),
lockscheme(),
next_identity(),
object_id(),
object_name(),
pagesize(),
pointer_size(),
ptn_data_pgs(),
reserved_pages(),
reserved_pgs(),
rowcnt(),
row_count(),
showplan_in_xml(),
syb_sendmsg(),
syb_sendmsg(),
System Functions,
tempdb_id(),
tran_dumpable_status(),
tsequal(),
used_pages(),
used_pgs().
|
