da, apare in sys.dm_db_index_usage_stats
/*
CREATE FUNCTION INDEX_ID
( @table sysname,
@index_name sysname )
RETURNS int
AS
BEGIN
DECLARE @indid int
SELECT @indid = indid FROM sysindexes
WHERE id = OBJECT_ID(@table) AND name = @index_name
RETURN @indid
END
GO
*/
SELECT
dbo.INDEX_ID('tbl1', 'iStatusCode')
select
* from sys.dm_db_index_usage_stats where database_id = 5 and index_id = 9
5 1410924198 9 0 1 0 0 NULL 2009-01-07 15:44:50.487 NULL NULL 0 0 0 0 NULL NULL NULL NULL
multumesc.
alex.