CREATE TABLE [LoginData] (
	[LoginID] [int] IDENTITY (1, 1) NOT NULL ,
	[LoginDate] [datetime] NOT NULL CONSTRAINT [DF__LoginData__Login__3CA9F2BB] DEFAULT (getdate()),
	[LogoutDate] [datetime] NOT NULL CONSTRAINT [DF__LoginData__Logou__3D9E16F4] DEFAULT (convert(datetime,'')),
	[UserID] [int] NOT NULL ,
	[CourseID] [int] NOT NULL ,
	[Username] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_LoginData_Username] DEFAULT (''),
	[NotFound] [bit] NOT NULL CONSTRAINT [DF_LoginData_NotFound] DEFAULT (0),
	[RemoteIP] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__LoginData__Remot__3E923B2D] DEFAULT (''),
	[ResWidth] [smallint] NOT NULL ,
	[ResHeight] [smallint] NOT NULL ,
	[Browser] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[BrowserType] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_LoginData_BrowserVendor] DEFAULT (''),
	[OSMake] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_LoginData_OS] DEFAULT (''),
	[OSModel] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_LoginData_OSModel] DEFAULT (''),
	[BrowserMake] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_LoginData_BrowserMake] DEFAULT (''),
	[BrowserVersion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_LoginData_BrowserVersion] DEFAULT (''),
	CONSTRAINT [PK__LoginData__3BB5CE82] PRIMARY KEY  CLUSTERED 
	(
		[LoginID]
	) WITH  FILLFACTOR = 80  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE PROC usp_ShowStatDate
	@tabmask sysname='%', 
	@indmask sysname='%'
AS
	SELECT 
		[TableName] = LEFT(CAST(USER_NAME(uid)+'.'+o.name AS sysname), 30), 
		[IndexName] = LEFT(i.name, 30), 
		[Type] = CASE WHEN INDEXPROPERTY(o.id,i.name,'IsAutoStatistics')=1 THEN 'AutoStatistics'
			WHEN INDEXPROPERTY(o.id,i.name,'IsStatistics')=1 THEN 'Statistics'
			ELSE 'Index' 
			END, 
		[StatsUpdated] = STATS_DATE(o.id, i.indid), 
		rowcnt, 
		rowmodctr, 
		[PercentModifiedRows] = ISNULL(CAST(rowmodctr/CAST(NULLIF(rowcnt,0) AS decimal(20,2))*100 AS int),0),
		[NoRecompute?] = CASE i.status & 0x1000000 
			WHEN 0 THEN 'No' 
			ELSE 'Yes' 
			END, 
		i.status 
--	SELECT	TOP 10 *
	FROM	dbo.sysobjects o 
		JOIN dbo.sysindexes i 
			ON (o.id = i.id)
	WHERE	    OBJECTPROPERTY(o.id, 'IsUserTable') = 1 
		AND i.indid BETWEEN 1 AND 254
		AND o.name LIKE @tabmask
		AND i.name LIKE @indmask
	ORDER BY StatsUpdated DESC, TableName, IndexName
/* TEST RIG

SELECT [ServerTime]=GetDate()
EXEC usp_ShowStatDate

*/
GO