|
|
| Definitions More Info. | | Definition ID | 203 | | Title | SQL | | Category | SCRIPT | | Definition | TABLE_DATA_MODIFY_LASTDATE_KULLANIM | | Definition Description | select * from CompanyRight
SELECT
OBJECT_NAME(OBJECT_ID)AS TABLENAME,
last_user_lookup,
user_lookups,
last_system_lookup,
last_user_scan,
user_scans,
last_system_scan,
last_user_seek,
user_seeks,
last_system_seek,
last_user_update,
user_updates,
last_system_update
FROM
sys.dm_db_index_usage_stats
WHERE
database_id = 13 -- DATABASE ID DEGISTIRMEYI UNUTMA
AND OBJECT_NAME(OBJECT_ID)='CompanyRight'
--AND last_user_lookup IS NULL
--AND user_lookups <> 0
--AND last_user_scan IS NULL
--AND user_scans <> 0
--AND last_user_seek IS NULL
--AND user_seeks <> 0
--AND last_user_update IS NULL
--AND user_updates <> 0
ORDER BY
TABLENAME | | RecordBy | cunay | | Record Date | 25-06-2012 13:11:30 | | Düzenle |  | | Kopyala |  | | Sil |  | | |
|
|