SELECT create_date
FROM sys.tables
WHERE name='tblUsrShrProp'
SELECT [name] ,create_date ,modify_dateFROM sys.tables
SELECT su.name,so.name,so.crdate,*
FROM sysobjects so JOIN sysusers su
ON so.uid = su.uid
WHERE xtype='U'
ORDER BY so.name
SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'developer')
AND OBJECT_ID=OBJECT_ID('tblusrshrprop')
No comments:
Post a Comment