Who has accessed my SQL Server

SELECT I.NTUserName

     , I.loginname

     , I.SessionLoginName

     , I.databasename

     , Min(I.StartTime) as first_used

     , Max(I.StartTime) as last_used

     , S.principal_id

     , S.sid

     , S.type_desc

     , S.name

FROM sys.traces T CROSS Apply ::fn_trace_gettable(T.path, T.max_files) I LEFT JOIN sys.server_principals S ON CONVERT(VARBINARY(MAX), I.loginsid) = S.sid

WHERE T.id = 1 And I.LoginSid is not null

Group By I.NTUserName, I.loginname, I.SessionLoginName, I.databasename, S.principal_id, S.sid

     , S.type_desc

     , S.name

save Excel Worksheet to a new file

http://www.ozgrid.com/forum/showthread.php?t=69601

PowerPoint Automation from Access

http://msdn.microsoft.com/en-us/library/aa159920.aspx

IDENT_CURRENT

SELECT IDENT_CURRENT ('tblTaskRFP') AS Current_Identity;

http://msdn.microsoft.com/en-us/library/ms175098.aspx

Date conversion

SELECT @TodayAtNoon = CAST( CAST(Month(getDate()) as nvarchar(2)) + '/' + CAST(Day(getDate()) as nvarchar(2)) + '/' + CAST(Year(getDate()) as nvarchar(4)) + ' 12:00:00.000' as datetime)